Transpose column on one sheet to row on another with linking

Question

In worksheet A, let's say A1:A10, I have a column of data. I have a range of data from A1 to J1 in worksheet B. I require a data transposition from worksheet A's column to worksheet B's data range. I can use Paste Special to insert the values, but I need worksheet A's data to automatically update worksheet B's data.

Answer 1

select A1:J1 in worksheet B and enter:

=TRANSPOSE('worksheet A'!A1:A10)  

with Ctrl+Shift+Enter.