Appending Multiple Worksheets

  • Thread starter Big Daddy Train
  • Start date
B

Big Daddy Train

Hi

I've been sent 85 single worksheet files (none of which
are very big) and I want to create a master spreadsheet
that contains the contents of all of them - but I don't
want to have to open each spreadsheet and copy and paste
them into the master.

Is there a quick way of inserting the contents of multiple
spreadsheets into one? All of the sheets are in an
identical format.

Thanks!

BDT
 
Top