Data merging and cleaning of about 47,000 records from 8 different excel worksheets - repost 2

This project has been posted a couple times because we keep adding more records to our dataset - I now have about 47,000 records of companies from 8-10 different sources in excel tables. The data has a number of different fields with some tables having more data than others. I have mapped all of the fields and most of the tables have a minimum of :: BUSINESS NAME :: ADDRESS :: CITY, STATE, ZIP :: PHONE :: FAX :: EMAIL ::WEBSITE :: Contact Name :: SOURCE :: Additional Fields could include: Keyword (specific to source), Primary NAIC code, Primary and Secondary SIC code, rating (Yelp, Yellowpages, Houzz), Trade Associations, Project Size, Year Established, Category, License(s), Geographic area served, Map ID (URL) and others... I would like bids for the following data merging and cleaning deliverables: :: combine files into one master file encompassing all of the fields available across the files (save this file separately) :: merge any duplicate records, appending any additional fields so that each company record is complete :: remove any duplicate records that couldn't be merged to or appended to the other existing records (save this as a separate worksheet) :: sort by state and provide me with counts by state (please enter summary in separate worksheet) Accuracy, and attention to detail are key for this project. We are looking for someone with SQL or high level excel skills to complete this task using scripts or cleaning tools. After as much automated merging and cleaning as possible can be completed, please review a sample of the records manually to ensure accuracy. We will check final records for accuracy and to ensure that no companies have been deleted.... Looking forward to working with you. We will select a bidder ASAP and hope the project can be completed in a few days.