Excel 2007 : Merge excel files with different column headings

Hello,

I'm new here so please forgive any naivety. I have about 100 excel workbooks that contain essentially the same types of data. Each file details plant collections of certain people and each plants corresponding habitat, date collected, locality, county, state, species etc. Yet they have many different column names for the same things (I.E., date collected = collection date = Col_date = coll_date)

How could I go about combining all of these files into one, while keeping the columns matched up? I want the data in File #1 under the column heading "Date Collected", to be under the same column as the data from File #2 with a column heading of say, coll_date.

I've imported all of these into Access as separate tables and thought maybe I could use SQL to do something but I just am not sure what to do.

Besides copying and pasting for hours on end, I have no real solution to this problem.

Any help is much appreciated!

I've attached a zip file with an example of workbooks I need to combine.

Hi,

There are many ways to merge multiple excel files like using VLookUP Formula, VBA Script and Using some Excel tools or Add-in. Try Synkronizer Excel Tool. Synkronizer is very simple and user-friendly Excel Add-in. With this add-in, you can merge hundred of excel files just with a few clicks.