linking to open workbook

[Mile029]

can we link cells to a workbook that is open at the time? I want to be able to have the values in one workbook change as I open another workbook. So anytime I open another workbook, it knows that to take the values from that workbook, kindof like a live link. Is that possible? thanks.

let's give some examples, if this helps:

workbook "A" contains links to workbook "B"
workbook "B" has info in different tabs
now workbook "C" has different info in different tabs but the info is in the same location as workbook "B"
so in workbook "A" cell B5 I link info from tab "test" in cell A1 (value is $100) of workbook "B"
so now it says in cell B5 of workbook "A" $100
now if I open workbook "C" it also has a tab called "test" but value in cell A1 is $75
how can I get workbook "A" to now say $75 in cell B5 without having to remap the links to workbook "C"?
I want to be able to open workbook "C" and when I open workbook "A" and it asks to update the links and I click yes, it takes the info from workbook "C" and not still be mapped to workbook "B" (and vice versa).

Is this possible?

[Mile029]

anyone have any ideas?