Hello:

I have a large number of spreadsheets in a folder with the following naming convention:

ITProject-00001.xlsx
ITProject-00002.xlsx
...
ITProject-00135.xlsx

These spreadsheets contain summary information for projects such as:
ProjectTitle
ProjectManager
ProjectSponsor
ProjectStartDate
ProjectEndDate
ProjectStatus

I would like to have information linked from these workbooks to a ProjectDirectory.xlsx workbook

What I am trying to do is to build the links dynamically based on the project number (00001 to 000135) and have the fields above get pulled into the directory to create a concise and meaningful summary of all of the projects. For instance, building this link dynamically does not pull in the linked information:
'[ITProject-00001.xlsx]Project'!ProjectTitle


...where Project is the name of the tab on the source workbook.

It appears that building dynamic links in MS Excel is not working. (At least for me).

Does anyone have any guidance on how I can accomplish this?

Thanks in advance.
Matt