Scrape a website. Clean up & organise a spreadsheet. Remove duplicates.

I have a few spreadsheets. With data of people in a certain industry. Some spreadsheets contain influencers in an industry. With their twitter profiles & websites etc. Other spreadsheets contain company names, and individuals who work for these companies. Along with their company names. I need all of the contacts to be put into one large spreadsheet. So it is easily sortable. I would like all of the individual contacts to be appropriately labelled, according to the type of work they carry out, in the industry. The spreadsheets will contain things like. Company Name Email Website Contact Name Address1 Address2 Address3 Address4 Post Code Twitter Followers Twitter Account One problem. The email I have with some contacts is incorrect. It is missing parts of the email. Eg. The display email shows joebloggs @ c But the mailto link actually is joebloggs @ company.co.uk. So I will need this data to be scraped from a certain website. (15,000 emails) I have all of the contacts already assigned to a company they work for. And these companies are ranked in order of the top 200 companies in the UK. So I will need the new email addresses to be added to my existing list. Overwritten if you will. There is a good few hours work here.