Combining worksheets from multiple workbooks into a single worksheet in a NEW workbook

[excel4use]

I have with me tens of workbooks with me in a folder.
Each workbook has 3 sheets; however the data which I'm bothered about is in Sheet 1 for every workbook.

For each workbook, Sheet 1 data:

• consists of fixed number of columns but variable number of rows (some of them having 35000 rows).
• have fixed column headers in the first row.

I have a blank Master Sheet saved in the same folder mentioned above. I want to combine all the data from Sheet 1 of all the workbooks to Sheet 1 of the Master Sheet. First row of the Master Sheet should be the column header and combined data should start from second row.

Can someone help me with a macro to get the above job done.

Regards.

 

[Andrew Poulsom]

Welcome to MrExcel.

Look here:

Copy/Paste/Merge examples