Can anyone help me he

How do I setup transfering data in a row to a column on another sheet so
that when I input anything in the row, the column in the other sheet will be
automatically filled.

I tried =Sheet1!A1 and then copy down. But the second cell down becomes
=Sheet1!A2, whereas I want it to be =Sheet1!B1

Thanks in advance!