Linking set of worksheets between different workbooks!
 

Hi,

We have a workbook A- with 50 worksheets named as Week1 Week2 etc.
We have to create a new workbook B- with same number of worksheets, grabbing
values of 3 cells from corresponding A's worksheets.

B's Week1 will pull values from 3 cells in A's Week1
B'1 Week2 will pull values from same 3 cells in A's Week2 and so on..

HOw can this be accomplished without manually changing the SHeet name on the
formulas.
Thanks
Priya