Display values from 2 sheet in 1 sheet

[shahsn11]

Hi All,
I have a excel, containing 2 sheets Sheet1 and Sheet2. which contains values which i have populated using pivot table.

Now i want to display values in Sheet3 such that,

Value in column A of sheet1 should be in column A of sheet3 and
Value in column A of sheet2 should be in column B of sheet3 and
Value in column B of sheet1 should be in column C of sheet3 and
Value in column B of sheet2 should be in column D of sheet3 and so on....

I have to make it dynamic so what all i can used.
I tried Pivot table but still it is not working
Any help on this would be appreciated

Thank You

 

[mole999]

go to sheet 3 A, type = then navigate to your reference sheet on 1 and select the cell, press enter and it should be displayed, drag down to complete column, repeat for B. changing sheet3 will not update the refernce sheets, though if you delete a value you can just redrag the formula

 

[shahsn11]

go to sheet 3 A, type = then navigate to your reference sheet on 1 and select the cell, press enter and it should be displayed, drag down to complete column, repeat for B. changing sheet3 will not update the refernce sheets, though if you delete a value you can just redrag the formula

Thanks for such a quick solution, but i would like to make this dymanic.Like i dont know how much columns sheet A contains. The solution you provided is good, but i will have to maually do in for approx 16K column

 

[mole999]

for a starter, it won't take too long to drag down 16 thousand, and then the B column, should just be a double click to extend it