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 ...