Linking data across sheets (horizontal auto fill)

[crius]

Hey guys, hope you can help me out.

The situation is as follows:

Sheet 1:


Column A:
1 a
2 b
3 c
4 d

Now i want to autofill all the values in "Sheet 1;Column A" into a horizontal column (line 1) in Sheet 2. How can this be achieved?

Sheet 2:

Column a Column b Column c Column d
1 (a) (b) (c) (d)
2
3
4