Excel links
 

I am trying to link 2 reports (different workbooks) together. I want
to link a row in workbook 1 in to a column in workbook 2. For example
I want to pull information from cells A1-Z1 into workbook 2 from B1-
B26. Right now I have to individually link each cell to the
corresponding cell in the other workbook. Does anyone have a
suggestion on how to make this easier?