Hi,

I have data in multiple sheet. I need to align them side by side in a mastersheet.

Example:
In Sheet1, I have a the data as
1 a 9
2 b 8
3 c 7
In Sheet2, I have the data as

h 3 z
j 4 y
k 5 x

Now in the master sheet, i want the data to be aligned as

1 h a 3 9 z
2 j b 4 8 y
3 k c 5 7 x

Can anyone please help. Thanks in advance.