Amalgamation of business information data sets

The job is to amalgamate multiple business data record spreadsheets into a single sheet.

For example, a business record (name, address, ID, telephone number, etc) may appear in one or multiple sheets. The data for the business needs combining into a single row.

There are a mixture of between 2000 and 6,000 records per sheet. There are 4 to 5 sheets in total.

If the job is done well there is an opportunity for work on an ongoing basis.