Create continuous non blank table based on merge of separate dynamically filled tables

Sure, sorry I realize my question is rather vague! I have created a sample workbook where Sheet1 contains the tables which are populated through a separate sheet/user forms, and Sheet2 has the table (could simply be a range) with the data populated as I need it to appear.

Whenever the tables in Sheet1 get row data added/deleted, I want the master table in Sheet2 to be updated to contain all the data grouped without any spaces between the "City" table data.

I have been trying some variations of array formulas that find the last empty cell/row in an array but that does not seem to address my issue so I wonder if the solution might be with VBA.