Yes, you can sync multiple tables into one table.
If you create a synced table, you can choose to add a new sync source.
Refer to my screenshot below.
As a side note, I think(?) there might be restrictions on your number of internal syncs.
I’m not exactly sure.
If you are truly doing a summarization, you could create a common field in each of the 8 tables that corresponds to the unit of aggregation that you want to use (like day, month, year, etc). This field will be a link field to another table (Let’s call it “Summary”), used for compiling summary stats. Fields in this table will the linked fields to all the other tables plus rollups. The downside is that it is one more field to enter in every table, but you could likely automate it. The upside is that you don’t needlessly use up your record allowance.