Absolutely. Just use the TransferText method to export your data. Specify
the same Excel file and each query will get exported to a separate tab.
You can do it in a macro or in VBA:
DoCmd.TransferSpreadsheet acExport, 8, "Query1", "C:\MySpreadsheet",
True, ""
DoCmd.TransferSpreadsheet acExport, 8, "Query2", "C:\MySpreadsheet",
True, ""
DoCmd.TransferSpreadsheet acExport, 8, "Query3", "C:\MySpreadsheet",
True, ""