how to link two workbooks when part of the filename change

Hello all!

I have designed a workbook to track project resource. The idea is that for each project a copy of this sheet would be made by the project manager. The users will be saving their sheet as "Project Cost - xxxx' where 'xxxx' would be the project name. The idea is that, through validation (I can figure this out) overallocated resources will show in red thanks to a formula between the various workbooks. My issue is that the filename will always be different with the word "Project Cost -" being the only common elements. Any idea how proceed?

If you are looking for a quick uncomplicated solution you can do the following:

1) press CTRL + H
2) Type the old file name in the 'Find what' field
3) Type the new file name in the 'Replace with' field
4) click on [Options]
5) Change the 'Within' drop-down to "Workbook"
6) click on the [Replace All] button