Data consolidation conundrum...

Sorry Andrew, have just managed to get the image to show and have solved your issue using Power Query (Get and Transform).

See the attached example.

Head to the Data tab, click into the first table, and then click 'Get data from Table'. Close and load to a table.

Click into the second table, close and load while creating connection only.

Go back into the first query, merge the query with the second table and bring through the email address.

This is by the far the simplest approach.