How can I create a horizontal link to a vertical cells in another work sheet?

I have sheet A and sheet B.

Sheet B has a column.
I want this to create a link to Sheet B in Sheet A - I can do this for individual cells, by doing:

=SheetB!A1

for example.

But: how do I copy one column and and apply it a row in the other spreadsheet?

I've read up, and can do this for values by using 'Past Special' and choosing 'Transpose'.

I don't cant to copy just the values: I want to create a link, so that if cells change in SheetB, then they change in SheetA.

Apart from doing this manually: I can't figure out how else to do it.

Thanks.


Omar