Table to sort & display the last 30 results

So as you enter a new date on the DATA Sheet (Table1), you want it to automatically show up in the Table on the RESULTS tab?
I'm not sure, but I don't think you can do that with a table. However, you may be able to do what you want with Dynamic Array Formulas. I *think* you get those with V2019, don't you. If you don't, this won't help you, but if you do, maybe you can use this.
In H4, try this:
=SORT(UNIQUE(FILTER(Table1[DATE],Table1[DATE]>=LARGE(UNIQUE(Table1[DATE]),30))),,-1)
I4:
=COUNTIF(Table1[DATE],H4#)
J4:
=COUNTIF(Table1[DATE],H4#)*2+COUNTIFS(Table1[EXEC 1 SIZE],"<>",Table1[DATE],H4#)
k4:
=COUNTIFS(Table1[G/L],">0",Table1[DATE],H4#)/COUNTIFS(Table1[DATE],H4#)
L4:
=SUMIFS(Table1[G/L],Table1[DATE],H4#)
M4:
=SUMIFS(Table1[G/L $],Table1[DATE],H4#)

See attached.

Thanks, you are correct in what I'm looking for though neither anchorarray or sort works in v2019. I think I would also need to normalize the range as well.

With regards to the other columns of data... they should auto populate, as they are, when a Date entry is populated. As of now, if you simply add a new row with a date, those other columns of data are populated automatically.

Looking at the formula in RESULTS O15... Can I not modify it to get the result I want some how? That formula works for my weekly results table.

Thanks, though I have that table figured out, its getting the daily date in the other table to auto populate that this thread is about.