Hello All,

I have multiple workbooks inside that multiple worksheets are available, i wanted to merge all the worksheets data into one excel file.
Ex.
Book1
A B C
5 1 7
4 5 8
4 6 9
2 9 7
6 10 4
9 10 4
10 10 10

Book2
D E F
55 59 56
57 54 59
53 54 50
60 56 51
51 53 52
55 56 56
58 60 50
60 52 56
51 50 50
53 53 52
55 54 50

OutPut should be

A B C D E F
5 1 7 55 59 56
4 5 8 57 54 59
4 6 9 53 54 50
2 9 7 60 56 51
6 10 4 51 53 52
9 10 4 55 56 56
10 10 10 58 60 50
60 52 56
51 50 50
53 53 52
55 54 50
Could you please help me resolving this issue. Many thanks in advance.

Best Regards,
Raj