Combining Multiple Tables

Hi, I've been assigned a task where I need to combine user data from around 20 tables into just 1. The tables all have different amounts of rows so they don't all have the same users and the only thing they all share is an email address field.

I had a look at Power Query but it appeared that the tables needed to have the same amount of rows? I tried to combine the tables using PQ but I couldn't get it to append the non-matching rows from the second file to the merged table.
Can anyone point me in the right direction please?

Can 1 email address be associated with more than 1 service? Please read the yellow banner (top) act on its guidelines and post a SMALL, RERESENTATIVE sample Excel sheet.

Hi Glenn, apologies I thought there was a post requirement to add the file, it's on there now. Yes an email address can be used in more than 1 service. There'd be around 20 tables but for example, table 1 could have 500 email addresses, table 2 could have 300 addresses but only 200 addresses are matched between the 2 tables, in which case I'd want the unmatched ones to be appended to the end of the table.
If there isn't really a way to do this natively in Excel then I can write something in VBA to do the task, but I thought I'd check here first.