open folder that has multiple worksheets ,copy specific data from a tab and paste them

[Kh.diab]

Hi Gurus,

I really need your help !
I have multiple excel sheets in a specific folder (ST8204 template.xlsx , ST9138 template.xlsx)
And I want to copy specific data from specific tab(named inv-oracle) in these worksheets
And paste it to a master sheet with a standard format(here named Sales Order destination.xlsx)
As header and its lines to form a template

Find my attached files
master sheet is Sales Order destination.xlsx and the sheets where i want to copy from is
ST8204 template.xls and ST9138 template.xlsx

I really appreciate your contribute


Regards

 

[Deepak]

Will loop soon....