You can do it by running your query and then choose File|Export and selecting Excel as the File Type and then entering a Spreadsheet name. Then run the next query and do the same thing, except choose the same file you just saved the last one into.
If you want to do it with a Macro, create a new Macro and use TransferSpreadsheet and select Export, enter the query you want to export and enter the full path and file name that you want the data exported to. On the next line do the same thing but change the name of the query you are exporting from. Save the macro and run it.