Excel 2011 VBA Macro Query - Copy cells from consecutive worksheets and paste sequentially underneath each other on output page with a loop function

[escartin]

I have data from (row 1, column 1) to (row 53, column 5) on 283 consecutive worksheets in a singular excel file that I would like to be presented on a singular worksheet starting from the data on worksheet 1 and descending to the data on worksheet 283.

I am looking for a copy and paste loop solution that will copy the data from each page and sequentially paste the results on a singular output page in descending order (worksheet 1 data, worksheet 2 data... etc) so that I can sort the data.

Any support is much appreciated.

Many thanks for any ideas about how to best achieve this result using a macro.

 

[jbeaucaire]

'MANY SHEETS TO ONE SHEET
Here's a macro for merging data from multiple sheets into a "consolidation" sheet where the source sheets are the same layout.

Sheets to One Sheet - Part 1​

There's a sample file there, too, to make it easy to try it out.