If you want a new summary sheet of all the other sheets in a workbook, I'd recommend a macro for that.
'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.There's a sample file there, too, to make it easy to try it out.
Edits I'd recommend:
Change the name of the SUMMARY sheet to Consolidate and the macro will work, else you'll need to go through and edit the word "Consolidate" in the code "Summary".
Bookmarks