Multiple workbooks with multiple sheets in each

[flwoOrlando]

I am trying to write/find VBA code that can consolidate multiple workbooks that have multiple sheets into 1 larger file.

Each file/workbook is called by the month it was generated in.
Each sheet (and there are 12) are called in numberical order: 1, 2, 3, 4.... 12.
Each sheet has different headers, but the headers are the same for each sheet.

I am able to borrow vbs code that takes all 12 files, and merges each tab into the workbook, so i end up with a sheet 1 and sheet 1(11), etc...
I want 1 file with 12 sheets, with all the data from the 12 sheet1's in 1 sheet.

 

[alansidman]