Trying to reference a horizontal row in a vertical column

I have a large sheet of Data, which is arranged in rows, that I'd like to display on a seperate sheet in columns.

So on
Sheet1A1 would be Sheet2A1
Sheet1A2 would be Sheer2B1
Sheet1A3 would be Sheet2C1

and so on. I can copy-> Paste special -> Values/Transpose, and everything ends up in the right spot, but I need it to be a reference, so it changes/updates automatically, and I can't seem to find a simple way to do that.

I suppose I could do it by hand, but I have thousands of data points, it would take days. Is there a trick I'm missing?

Thanks in Advance,
Geoff

The second one worked, and once I new what to look for I read up on offset commands and learned a lot.

thanks!

Geoff