Merge multiple worksheet to single excel file

[Dattatray]

Dear all
Please help me to resolve this issue ............How to merge multiple excel to single file or worksheet ? With the help of VBA
I have 2 Link which is not working Properly

1) http://www.oaultimate.com/office/me...-into-a-single-spreadsheet-ms-excel-2007.html

2)

 

[Gangadhar Yeligaty]

Hi Dattatray,

Can you please share sample files?

Also let us know if all the files are on the same format.

Regards,
Gangadhar Yeligaty

 

[Dattatray]

Hi Gangadhar

Please find the attache sample file (abc & pqr ( i have more then 2 file for trail taken two file)