Exporting data from multiple tables into a single CSV

Is it possible to export data from multiple tables into a single CSV?

My thought right now is to build a 'combined table', and use automations to populate that table with the records I want from the other 4 tables.

Then it's a simple report on that new table.

Is there a way to accomplish this without actually having all the records in the same table?

------------------------------
Mike Tamoush
------------------------------