in PQ can we merge multi sheets in Multi Workbook at same time

[LearnMeExcel]

Hi all
i have 5 files for 5 regions
each files contains From 4 to 10 sheets ( each sheet for Product sales Anaysis )
i merged it by my PQ File file then i use PQ also to Merge it all in one file

that is mean i use PQ 5 times for 5 files
then i use it again to merge it all in one file

can i make all this steps one time in One PQ file

i hope it is clear for all

 

[sandy666]

maybe use From Folder option then merge sheets

 

[LearnMeExcel]

@sand666
i use it it in next step
i want by one step all data from multi sheets and workbooks

 

[sandy666]

you mean "one click and go?"

in post#2 I said From Folder then merge tables - this is one query

or explain what one step means to you

 

[LearnMeExcel]

Sandy i merge sheets in each file
then i use from folder

i asked if it is possible to merge sheets and file by one step

 

[sandy666]

i merge sheets in each file then i use from folder

this is 6 steps

merge sheets and file

From Folder then merge tables in the same query = one query = one step

or I don't understand your logic, sorry , maybe someone else

have a nice day

 

[LearnMeExcel]

yes i use around 6 steps
cuz from folder take only one sheet from all files
i want to take many sheets ( appended) in many files at one step

 

[sandy666]

cuz from folder take only one sheet from all files

who said that???

see

I suggest to read:

• What is PowerQuery
• Getting started with PQ
• PowerQuery Help
• PowerQuery M reference