How to take multiple Excel files and combine into one big file?

[G_Gilly12345]

Basically, I get an email every day at the end of the day, containing data that I need to enter into a master spreadsheet. Unfortunately, I've let it pile up for far too long and now it will take me far too long to open every one and put it into my master sheet. Just so you know, every column on these emails contains the exact same type of data. Address, Phone Number, First name, Last Name, etc.

Is there an add in or some software or, even better, a formula that I can use to combine all of this into one file, so then I can just copy and paste all the data into my master sheet? Thanks for any help and or direction you might be able to provide.

 

[Hui]

G_Gilly

Firstly, Welcome to the Chandoo.org Forums

This question has been answered many times

Please try the Search Box at the top right of every page at Chandoo.org

 

[pecoflyer]

Or Google around for "rondebruin"