Only indirectly, but there are a couple of options.
First would be a pivot table - it looks like Tables 2 and 3 are summarizing the data in Table 1, so it may be a good candidate for a Pivot Table.
Pivot Tables automatically expand to show the relevant data, so adding an additional Date on Table 1 would automatically extend Table 2.
Pivot tables can automatically handle running totals, and dividing out by month (or quarter, or year). Here's a quick Pivot Table I made of some sample data (I added extra data to extend into additional months so show the monthly breakdown):
Because of the potential overhead of the way pivot tables work, they are not dynamic - you'll need to periodically click the refresh button in the Pivot Table sidebar to have it update, but other than that, most of the work will be done for you.
The other possible path would be spilled columns.
Spilled columns (or rows) use formulas that return a range of values rather than a single value. Numbers can then spread (or 'spill') these values into multiple cells.
The only downside is that spilled formulas will throw an error if there's not enough room - for example, a formula that returns 10 columns, but there are only 9 columns on the table - you'll have to manually extend the table to ensure it has enough space for the spilled results.
Answers to some of the other discussions you've initiated also used spilled results, so this shouldn't be too hard to implement. A lookup to find all the dates, another to find all the months, and formulas to build the intersections. You'll just need to make sure the destination tables are large enough.
I'd also recommend flipping your table around. From the looks of it, you expect to extend this table to the right, up to 366 columns by the end of the year.
Tables generally work better when they're taller than they are wide. In other words, having the names across the top and extending the dates downwards. That way you'd have 365 rows for 9 rows (names), rather than 9 rows (names) for 365 columns. Your summary tables can flip this around if you prefer.
