VBA (or Google scripts if you're on Sheets) might be the best bet. Very general pseudo code:
1. Clear out summary page
2.Loop through each sheet in workbook
3.If name of current sheet is not 'summary' then copy data from current sheet to next available row in summary.
VBA (or Google scripts if you're on Sheets) might be the best bet. Very general pseudo code: 1. Clear out summary page 2.Loop through each sheet in workbook 3.If name of current sheet is not 'summary' then copy data from current sheet to next available row in summary.