Hi

I want to be able to have all the queries in the workbook (including the New one if poss) as the source for a New Query. I will then consolidate them into one output.

I have been given query - excerpt below

The Code currently requires all the Queries to be entered manually,

Is there a way that I can have this code pick up all other queries in the workbook as the Source for the query? In this way, as queries are added and deleted from the workbook the queries included as the source are updated automatically?

Thank You

Allister