How can I set Data Queries to be loaded in worksheets named as the queries themselves?

[excelos]

Hello!

How can I set Data Queries to be loaded in worksheets named as the queries themselves?

E.g. I have Query1 and when I run/refresh it, I want the results to be loaded in a worksheet named Query1, instead of Sheet1.

Thanks!

 

[maabadi]

Check this:

Get Multiple Files Containing Multiple Sheets with Power Query
​

 

[sandy666]

Power Query cannot change sheet name, you'll need to find vba to do that