Excel 2007 Data from many spreadsheets to one

Hello,

I'm trying to make a compilation spreadsheet inside a workbook (Excel 2007).


We have data from 83 different facilities that each have their own spreadsheet tab (this is for a very specific purpose not applicable to my question and it will not be changed).


The headings and formats of the different spreadsheets are 100% identical. The number of rows will vary in each sheet and change pretty constantly.


I would like to combine the data from each spreadsheet onto a single spreadsheet for a summary. I do NOT want to cut and paste every entry from the 83 tables onto the summary sheet.


How can I make excel pull the rows from each sheet and stack them, one on top of the other, on a new spreadsheet?


This is a SHARED workbook and as such, cannot use Advanced Filters or Pivot Tables.