Linking cells in Horizontal on one sheet and Vertical on another

Hi,

I need to display a set of information in both Horizontal and Vertical fields on separate sheets for different functions. I know how to paste the fields from Horizontal to Vertical ( basically converting a Row of data into columns. But I also want to link the data so if I fill in the Rows, the column cells stay sync'd

Its easy to do Row to Row or Column to Column, but I'm stuck on how to do it with the conversion ( aside from doing it one cell at a time)

Any Help would be appreciated

Regards,

OK, I am apparently being quite dense today.
Not quite getting the suggestion. As requested I'm attaching the file I am working on. What I want to be able to do is to take all the data in Column B of the BOM V sheet, and have it be linked to Row 5 (starting at Column F) on the BOM H page (I already did it for F5 and G5 as an example of the end result. That way when I update data on the BOM V sheet it stays sync'd with the date on BOM H sheet I just couldn't figure out the indirect or transpose functions to do what I am trying to accomplish

Thanks for the responses.

Try the formula below in F5 of BOM H, and fill right to the end of your data. It should copy the appropriate column B entry from BOM V.

=INDIRECT("'BOM V'!$B"&COLUMN()-3)

This seems to have done the trick, Thank you