Data Consolidation (3 spreadsheets into 1, some manual mapping / intervention)

Industry: Internet/Software
Analysis tool: Excel
Description of analysis: We need to consolidate data from 3 different contact/company information spreadsheets into one spreadsheet. The ultimate spreadsheet will have 2000 contacts maximum. The unique identifying column will naturally be the company name, however, this name will not necessarily be spelt the same in each spreadsheet. The spreadsheet with email addresses will be a lot larger than the other spreadsheets but clearly, we will only want emails related to the 2000 contacts to be imported, hence the need for assistance. I have attached 2 template spreadsheets so that you can see the structure of the columns: Template A & Template B. The 3rd spreadsheet is the ultimate consolidation spreadsheet that I want to be created. I also have a 4th template which is the one with the email addresses. PPH won't let me upload a 4th one! It will just show the following columns: Contact Name, Company Name, Position, City, Post Code, Email Address
Extra notes: Work needs to be delivered by 16th November 2017 latest, ideally before.