Hi all

I wonder if you can help me out on a problem
I have a number of account workbooks (about 25) that reference into a summary workbook, this is stored on an online data repository which we will call for example page A, they are all stored in the same area.
Every week these work books including the summary will need moving to a different location, for example page B. However the problem im having is that the reference still points to the location on page A. How do i get the reference to point to page B without having to rewrite all the references?
What i need to do is somehow use only the local path instead of the full path to the document because this stays the same
=INDIRECT is a bit impractical if all 25 source workbooks have to be open
Is VLOOKUP an option, ive never used it before

thanks

martin