Excel Spreadsheet cell (multiple issues)

I'll try to explain concisely what I am trying to do. I have reports from one company & reports from another - the information in the reports has one thing in common; an email address. I'm attemptin...