Place Power Query Result in a Separate Worbook?

[snaplink22]

Hello,

I am pulling 6 tabs worth of data into one table using Excel Power Query, however, I would like to Close & Load the combined data to a separate workbook and not the one where the data is currently stored at. Is this possible?

Thank you.

 

[sandy666]

pull data from any of the 3 files

any or all files?
did you try built-in feature :Data - New Query - From File - From Folder ?