Hey @sgoldenstein!
Unfortunately that is currently not possible, as you cannot sync different tables into one single table on a different base -would be super nice though. If you attempt to sync tables to a different base, you'd get the same amount of tables on a different base. I hope this doesn't sound confusing.
I would probably suggest consolidating all of such bases and tables, depending on your needs. If this is an issue for any reason, you can build a workaround that would sync the tables and bases via automation built in Make or N8N rather than Airtable's sync. -might be tricky, but for sure achievable.
I'll be submitting this as a feature request to Airtable!
In the meantime, I'd be happy to hop on a brief call and show you around best practices and insights. If interested, feel free to schedule using this link!
Mike, Consultant @ Automatic Nation