Hello all ,
I hope one of your expertise can sort my issue here..
Here is the details of my issues

I have so many different excel files with this below format. I would like to merge them on the product level and depot level.

Each excel files

started at rowm number 10

as below list ,

Section 40

week div Product Ship
201438 S 12 5
201438 G 11 12
201438 D AEN 20


section 50

week Country Location Dest Location Origin
201438 AA ABC DDD
201438 DA BBB GGG
201438 DE RTE CCC

I have whole years in a weekly period of datas in different excel files I would like to merge them all into one excel file and 2 separeate excel sheet one for product and one for country table..

Such as like
Product
week div Product Ship
201438 S 12 5
201438 G 11 12
201438 D AEN 20
201438 S 12 5
201438 G 11 12
201438 D AEN 20


Country
week Country Location Dest Location Origin

201437 AA ABC DDD
201437 DA BBB GGG
201437 DE RTE CCC
201437 AA ABC DDD
201438 DA BBB GGG
201438 DE RTE CCC
201439 AA ABC DDD
201439 DA BBB GGG
201439 DE RTE CCC



Thank you in advance if can anyone answer and find a proper solutions of my issue..