Excel organisation / data consolidation project

We are wanting to consolidate & organise 3 spreadsheets with varied data to fit within a master list, organised under the new header columns. Some information is new information that needs to be scraped / searched for, but is publicly available with Linkedin & Google.

Attached a master list below & a video of what we need is attached here: https://www.loom.com/share/0a02bf054d944c08926d73eef49a0f92