Export Access Report to Multiple Excel Tabs within a Workbook
This was available in a much earlier version of Access a long, long time ago. A report in Access is exported to a Workbook and each Group1 item in the report is sent to it's own Tab within a Workbook. Example: An Access report is grouped by SalesPerson, then exported to Excel and each SalesPerson name is sent to Tabs within the same Workbook with their corresponding data from the report.
Klaus Oberdalhoff commented
WIth transferspreadsheed you are able to do this ... just use the same file and different queries