Aggregate Data From Multiple AirTables

I have several AirTables (separate) that I use to track report status.

Is there any way to aggregate data from several AirTables and then sent a single email saying here are the overdue reports (Name field in AirTable)?

Or, I have to have a separate flow for each AirTable? Note that each AirTable may have more than one report overdue.

you can do this be aggregating each airtable to a CSV for example.
Then appending each CSV to the end of the previous one.
and then sending the final combined CSV, or passing it to the next set of modules.