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 th...