Transferring Data

[MJ]

I have a Workbook that has 12 tabs at the bottom. The tabs are named 14-26.
On this same workbook each sheet has columns A-Q.

I have another workbook (2) that I need to insert the data from workbook
one, Column B on sheets 14-26. But the information in the new Workbook (2)
should go up and down not across.

 

[Pete_UK]

Enter this formula in the first cell in column B of sheet 2 that you
want to use:

=INDIRECT("'"&ROW(A14)&"'!B2")

assuming you want to bring the data from B2 of every sheet (change the
B2 to suit). Then copy this formula down another 11 rows.

Note that there is an apostrophe ( ' ) between the first two quotes
and immediately before the exclamation mark.

Hope this helps.

Pete