Create an aggregate table of other different tables


Per the title, I would like to create a table (could be in a separate base if that is easier) that automatically or at least periodically updates with any new or changed rows from other tables.

Individual teams are going to be using project-specific tables that are formatted more or less the same so I would like to be able to automatically dump any new rows into one centralized table. The goal is to be able to use the API to dump the aggregated table into an RDS database and I worry that once multiple project teams are using it, I imagine it will become much more difficult to pull all of the new and changed records.

Is there a good way to go about solving this?


I’m also interested in this.