Merge different workbooks into one workbook. Setting order

[gubertu]

Hi all,

I hope you could help me with this.

I have 3 closed WB in a folder, in the following terms:

A) WB "A". With one sheet called "A"
B) WB "B". With one sheet called "B"
C) WB "C". With one sheet called "C"

I have another workbook, called "SUMMARY", in the same folder.

What I need is to copy these 3 sheets of these 3 closed workbooks, in the following order: first sheet "A", then "B" and then "C", in my open WB "SUMMARY".

It is possible?

Thanks in advance!

 

[sandy666]

try Power Query aka Get&Transform with From Folder option

 

[gubertu]

Thanks I will try this!