Here is a kludge possible solution if you really want it.
Create a a master generic table with enough columns to accommodate your widest result set. They'll probably need to be all character datatypes since you are mixing columns.
Insert your datasets, convert you numbers as necessary. Insert 2 blank lines. Insert column headings. Put a 'sort' column in your table and populate as you are inserting so you can control the sort of your final output.
Export the master table. You may have numbers in character columns but if this is a 'report' then that may be acceptable.
Alternate2-Have the Excel spreadsheet call the data from SQL server. Then you can control the location of the data.
Trying to automate a historical manual excel workflow is never fun. If you can convince the powers that be to accept an alternate format, all the better.