Link to corresponding tabs (worksheets)...

[lhedelson]

Hi! Using a workbook I'll call 'Workbook A', how do I link to corresponding tabs (worksheets) in another workbook, 'Workbook B'?

In 'Workbook A' I am using two cells. Each tab (worksheet) in 'Workbook B' is a different three letter code with the data in the same place (just different numbers), and in 'Workbook A' I want to be able to change the three letter code in one cell, and have the data change in the second cell simultaneously.

Is there a formula for this?? I've been trying h and v lookups and basically I just need to be able to figure out the 'table_array' part to those lookups.
Thanks so much!

[tuph]

If you zip a copy of your workbooks and attach it, it will be much easier for someone to work out what's required.