Exporting several queries to multiple tabs in one Excel spreadsheet

[Phil Smith]

7 different queries, one for each territory. I want to automatically
send each of those into it's own worksheet of the same workbook.

How?

 

[Ken Snell \(MVP\)]

See Create a Query and Export multiple "filtered" versions of a Query (based
on data in another table) to separate Worksheets within one EXCEL file via
TransferSpreadsheet
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#FilterExportSameFile