If I have data in columns per below:

A B C D
1/1/05 1/2/05 1/3/05 1/4/05

And I want the end result to be the below.

Row 1 1/1/05
Row 2 1/2/05
Row 3 1/3/05
Row 4 1/4/05

But as additional data is added, for example in column E (1/5/05), I want to
be able to copy the reference in row 4 down and have Row 5 reference what's
in column E and so on.

If I copy the reference in row 4, the reference moves down a row instead of
over a column. I know I can use paste values - transpose, but is there a way
to do this if I want to use and update cell references? Just as background,
I'm pulling data from another worksheet, which has to be formatted with the
dates across the top, but in my worksheet, I want the dates in one column,
but I want to reference what's being entered in the other worksheet.

Any help is appreciated.