Excel

[Bakedgoods]

Morning all,

Is there any way of combining lots of different excel spreadsheets into one without having to do it manually?

The formatting of them all is the same.

 

[Ice Globe]

Should be able to do it with the consolidate tool:

http://excel.tips.net/Pages/T003005_Condensing_Multiple_Worksheets_Into_One.html