Need Help in Macros to consolidate data from different files

[VinodKrishnappa]

Hi,

I need help in consolidating data from different excel files in particular folder. In all the excel files sheet name will be same, i need to bring all the data in these sheets into one excel sheet one after one.
For Ex. File names will be on month name & sheet name in the each file will be sheet1 & in each sheet i've data from row 1 to 400

I need to bring all the Sheet1 data of all months in one single file. That means Rows 400 X 12 Months in one single sheet.

Can you please help me on this.

 

[arthurbr]

Try RDBMerge, Excel Merge Add-in for Excel for Windows if an addin is OK
Or
Code at Merge data from all workbooks in a folder