Align data in multiple sheets in a mastersheet side by side

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.

Can you upload a sample sheet?

sujit_sarkar.xlsx

Is that whay you were after?

Hi Jenni,

The sample file is exactly what i was looking for.
I tried to find a work around with the formulas but my knowledge in excel is limited.