Auto-Size Tables Based on Feeder Tables' Inputs

So this issue is not as simple as it seems.

I do not want solutions for Power Query. This issue is for applying to a tool for a different end-user. We use O365 desktop software.

I have two tables, Table1 and Table2, for the purpose of pasting raw CSV data. Some days there are 150 rows, other days there are 200 or 140 rows... Row counts vary. Table1 can also have an unequal number of rows compared to Table2. When adding raw data, a table naturally expands for more rows, but does not do the opposite for fewer rows.

Table3 is the combined table, where I use direct references to pull in data via "=Table1[@Col1]", for as many columns as I need. Table2 data is then XLKP'd into Table3 via a primary key column in Table1 and Table3.

I am effectively creating a LEFT JOIN using Table1, but need Table3 to auto-size itself. The problem is that Table3 will NOT auto-expand the number of rows when there are more rows in Table1 than Table3 currently has.

I have tried named ranges instead of tables, but the user prefers pivot tables and the features of actual tables in Excel, so using ranges and dynamic arrays are not the solution this time. (I love DA's but end users need more flexibility).

So I am requesting solutions on how to get Table3 to auto-expand (and even auto-shrink but I do not believe that exists).

I have exhausted Google.. it keeps telling me to use PowerQuery and dynamic arrays. The LOL part is that tables HATE having dynamic arrays in them, so i think it's funny that google recommends it.

Also, I believe i remember solving this problem in the past, but it eludes me.