Multiple Queries as Source in a Power Query

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

Please Login or Register  to view this content.

Futher Code continues