linking and transposing two worksheets
 

I am having trouble creating a link between two worksheets.
I have essentially copies of the same worksheet but one is horizontally
arranged and the other is vertically arranged. I want to be able to update
either one of the worksheets, and then excel to automatically update the
other. I have tried linking them but as in one the data is horizontally
arranged and the other is vertically arranged it doesn't work.
I have tried creating a new workbook and using this formula;
=INDEX(.....COLUMNS($A:A),ROWS(1:1)) but this only seems to coppy and I
cannot update both sheets by inputting data into another?
Does anyone have any other suggestions? Thank you!!