We help IT Professionals succeed at work.

VBA code to merge multiple excel workbook to one

I have four excel files and want to merge all data of sheet1 of each workbook to a new excel workbook.
It would be great if someone provide me sample easy VBA code for that purposes.
Thanks in advace for your prompt response.

Thanks
Comment
Watch Question

BRONZE EXPERT
Top Expert 2010
Commented:

Author

Commented:
Hi
I reviewed the code.
As my understanding it will create a summery workbook which copy sheets from multiple source workbook( excel files )

Actually, I am looking for VBA code to merge all sheets from different excel workbook (excel files) to one summery sheet.

For example: I have 4 source excel workbook( test01.xls, test02.xls, test03.xls and test04.xls.
each excel file has uniqe sheet name. I want to copy all data of sheet named "A-I" from test01.xls, all data of sheet named "J-O" from test02.xls, all data of sheet named "P-T" of test03.xls and all data of sheet named "U-Z" to one sheet named "summery" of target workbook test05.xls.
Therefore, sheet named 'summery' of target excel file test05.xls contain a single sheet of data from all source sheets above.

It would great if you provide me VBA code for that purposes.

Thanks

Author

Commented:
I am still waiting for response. I would request to review my previous comment what exactly I am looking for.

Thanks

Author

Commented:
If anybody advise me with sample VBA code to merge different excel file(1st sheet per file) to one sheet in a defferent excel file.
Thanks in advance for your prompt response.

Waiting for sample VBA code for a faster way to do this.

Author

Commented:
Thanks

Explore More ContentExplore courses, solutions, and other research materials related to this topic.