Linked records from multiple synced tables

I made a Base that is meant to compile tables from various other bases. I’ve pulled in these tables and set up automatic sync. I would also like to create a Summary Table within this Base, and pull the records from these synced tables into this Summary Table. However, the “Lookup Field" I am trying to use for this Summary Table only allows me to pull linked records from one other table and not the multiple tables that I need. Can anyone suggest a workaround for this, or an app that might help?

Have you looked into a table that syncs from multiple sources? This is the easiest way that I can think of to collect data from multiple tables into a single table.