Macro Running Qurey with Multiple Criterior for Export to Spreadsheet

[Bill]

Hi All,

My skills are such that I need to do this with a macro if possible.

Currently I have five virtually identical queries with slightly different
criteria that I need to transfer to spreadsheet. I am ok with the transfer
to spreadsheet because that is how I am doing it now, but can anyone suggest
how, instead of having multiple queries, I can use one queries that I feed
different criteria to please.

A macro based approach preferred please.

Regards.
Bill