Sync Multiple tables into one table

Hi, Airtable community

I have tables from multiple vendors. Each table has the same fields. I have to combine the records from each of these tables into one table.

is there a way to combine multiple tables into one table? One thing I tried to sync table but multiple sync option is not available.



I’d like to do something similar: sync all my various client and project bases’ To Do lists into one master To Do list (and sync to my calendar). Love to know how to do this!