Find and Replace text within string

Hi Leith,

Thanks for the quick reply,

In answer to your questions no the link is not part of the cell formula, I will try and explain what results I am looking for.

I have designed a workbook that will show me financial data from 25 projects, the sheets in my workbook are exact replicas of the finance sheet, at the end of each month I have to report on the financial position of these projects. To prevent me having to open each workbook and print the pages I created one workbook, however these projects are subject to change, new ones will open and old ones will close, but 25 seems to be the consistant number.

Each Project is assigned a six digit number I would like to enter these numbers in to cells on a sheet which then in turns updates all the links in the workbook, including the sheet names if that is possible.

I have attached an example layout.

Hi Leith,

That is correct. I would like the links in the workbook to be changed according to the project numbers on the Data sheet.