Not sure if there is a direct way to do this, but you can create temporary table with Jet SQL(Access SQL).

Create separate INSERT queries which will insert the data needed into this temporary table and then just one SELECT query with all data into an Excel file.

Then you can also drop your temporary table with VBA/JET SQL.