PQ - Retreiving Just Ranges with Widcard

Hi

I have a large workbook with upto 50 sheets - each sheet has a range of 20 col and 20 rows. Each range has a unique name that starts with "Range".

I have tried to set up a Query in the workbook to retrieve ranges in the workbook where the name starts with "Range". However it takes 5-10 minutes to make teh conection.

Is there a way I can get it to just pull ranges where the range name starts with "Range".

The attached file is very small and simple but is supplied to facilitate a solution.

Kind Regards

Allister