combine multiple spreadsheets into one workbook

[Jen]

i have approx 800 individual excel files. i want to put them all into one
excel workbook - creating one workbook with 800 worksheet tabs.
Is this possible without opening them all and dragging them into the one
workbook one at a time?

 

[Duke Carey]

Jen - You may run into a limit on the # of tabs in a workbook. Not sure
about that. Even if there isn't a limit, you are looking at an enormous
amount of memory required to open such a workbook. However, if you want to
try, look at Ron de Bruin's add in that will merge workbooks

http://www.rondebruin.nl/merge.htm