I'm trying to get a table "transposed" by referencing the cells in another
worksheet. Currently it looks something like this

January February March April
M1
M2
M3
M4

I'd like it to look like this, while maintaining a dynamic link:

M1 M2 M3 M4 M5
January
February
March
April

I'd like to be able to reference the first cell and then drag the formula
either down (instead of rows incrementing, the columns would increment) and
the same for dragging the formula to the right. Is this possible????

ie
D1 D2 D3 D4
E1 E2 E3 E4
F1 F2 F3 F4

where D1 was the first reference brought in and the rest were dragged and
filled from there.

Can anyone help???