Consildate different Excel files into one

[LisaUK]

Hi Everyone,

I have had a look around on how to consolidate around 12 spreadsheet files into 1 but cannot find anything as yet. All the spreadsheets have the same field headers I just need the data be merged into one file from all the various files that I am using, something that would save a lot of copy of pasting.
Any ideas on this would be appreciated.

Thank you
Lisa

 

[Andrew Poulsom]

Start here:

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

 

[LisaUK]

Hi Andrew,

Thank you for that the Mergetool works great!

Lisa