Dear all,

I am unsure how to search for this due to the nature of my problem but I was wondering whether you guys could help.

I need to collate data from about 100 spreadsheets, each with a number of columns (say 10-12) and about 10-50 rows in each, and then place this data in a Master spreadsheet.

For example, if I had a table of Names, eye colour, height, occupation of 100 different companies, I need to make 1 spreadsheet with the company name and then all the different parameters.

The reasoning for this is to allow users to find common company data to use as a comparison for new business, without having to search through each and every spreadsheet on the system. Copying and pasting will take far too long.

Also, to add some slight confusion, the headings on each table may be different. i.e. "Eye colour" may be called "colour of eyes" on another table.

Any assistance will be much appreciated. I am NOT an excel wizard but am very good at following instructions.

Await your comments suggestions.
Jamie