Need Help in VBA code for Excel 2010 to combine multiple sheets in multiple workbooks into master workbook

[Mandar2469]

Hello :

I need a help in VBA code and am working in Excel 2010.

I have multiple a files (workbooks) and each file has 3 worksheets with the same name. I want to combine the data in single master workbook having same name worksheets and the data need to come in respective named worksheet, one after another (one below other).

Example -
The workbook (file) names are like = Tracker A.xlsx, Tracker B.xlsx, Tracker C.xlsx
The master workbook is = Tracker MIS.xlsm
The worksheet names = Sheet 1 as Requirements, Sheet 2 as Schedule and Sheet 3 as Data

Pl note, all the workbooks including file - Tracker MIS, has these same worksheets plus few more as reports.

For each worksheet the first 6 rows are header OR likewise information and the data starts from row 7 onward say A7 onward.

Can someone help Pl by sharing a VBA code ? any more info. is needed, I can share ....


Thanks in advance ....

Mandar
=============