I have a spreadsheet that contains approx 40 sheets, with Columns A to L.
Each sheet contains the same header row, but from 1 to 17,000 rows.

I need to combine all 40 sheets to a new sheet, preferably without including the header row (ROW 1) from each sheet apart from the first sheet.

I have tried some code I found online, but this only merged 99 rows for each sheet, and when I played with the numbers on the Macro this jug gave me an error.

the number of rows will vary week to week and possibly the number of worksheets. Therefore I would prefer not to need to define an exact number of rows, but perhaps an upper limit would be ok.

Any ideas guys?

much apprecuiate any assistance,
Dave