Merge Multiple Excel Workbooks and Map Headers

Hello Everyone,

I've been reading a lot of different posts here and on other forums, as well as crawling Google looking for a viable option for what i'm hoping to accomplish. So far, not a lot of luck. I have about 90 different Workbooks (and for simplicity sake, each only have one worksheet, i think) that I need to merge into one master workbook in a single sheet. Each workbook contains a list of sales leads from a different source/provider. This is what is causing the problem. Each sheet has some of the same data, but it is in different columns with different head row naming. For example, workbook one may have first names labeled as "fname" in column A, while workbook 2 may have it labeled as "first name" in column B, while workbook 3 has it labeled "first" in column R. It is like this in every workbook, and there isn't a whole lot of consistency among them... but there is in some (we may have 15 workbooks provided from one source, so those ones generally match up well, but it's hard to tell by filenames which workbook came from what source). Also, some workbooks may have columns that aren't in any other workbooks (for example, one workbook has a column labeled "date lead captured from 3rd party", which is not relevant to any other column in any other workbook), that i need to keep as well.

Is there any way to merge all the files into one by mapping the header rows to match? Hopefully I made this make sense, and maybe this is an Access job (looked for access solutions too, and couldn't find anything). Or even if anyone knows a program out there that will help accomplish this (even if it's a paid program).

Thank you in advance for any help or insight you guys are able to provide.

EDIT: and to clarify a bit, it's not just one column of data that needs to be mapped. For example, last names, phone numbers, addresses, etc also all are in different column positions with different header labels too, and i need everything of the same data type in the same columns.