Build a Excel Worksheet with information in different formats in multiple sheets. Will involve manual typing of information.

The Brief: To compile 1 list of all Companies that supplied product to each of the Clubs listed, across 2014, 2015, 2016. A main spreadsheet is provided to be updated with information, as well as each of the company below sales reports for 2014, 2015, 2016 years The Licensee/companies are: Company B, 2014, 2015, 2016 Company C 2014, 2015, 2016 Company D 2014, 2015, 2016 There will be gaps, as we don’t have information from Company A. The problem we have is that each club name is written/spelt differently in the sales reports provided by each company above to that in the main sheet/database. This means that most of this may need to be entered in manually. If you are unsure of any of the line items, please highlight in yellow, and I can cross check upon completion and update. There are 687 line items to be updated, by 2014, 2015 and 2016 years. Also, you will need to collate all total sales for each club for each year (687 lines). Not all figures will be provided in Company sales reports as a lump sum, so multiple lines may need to be added Please see following for example