Hi I have a small problem and need help from you guys, this has been eating me up.

I have 2 separate excel sheet and am trying to link them together via = value.

Sheet 1 has values vertically and for sheet 2 the same values will be horizontal (but need to be linked, if sheet 1 value changes then sheet 2 automatically gets updated).
Eg.

Sheet 1
cell A1 has value 1
cell A2 has value 2
cell A3 has value 3
cell A4 has value 4

Sheet 2
Desired value is (it should read like this)
cell A1 has value 1
cell B1 has value 2
cell C1 has value 3
cell D1 has value 4

I have tried using sheet 2 cell A1=sheet 1 cell A1 , but when I paste is in cell B1 the formula becomes sheet 2 cell B1=sheet 1 cell B1 whereas it should read sheet 2 cell B1=sheet 1 cell A2 so on and so forth

Formula requested urgently...PLSSSSS HELP

Thanks in advance