Linking of information from spreadsheets to a directory

[MattRobertson]

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

[Pecoflyer]

This add-in will enable to retrieve data easily

[MattRobertson]

Originally Posted by Pecoflyer

This add-in will enable to retrieve data easily

Thank you for the prompt reply!!!!

I had a quick look at the add-in description and have a quick question. Does the data have to be in similar column structures for this to function?

Ideally, I would like to pull individual cells from various locations on the sources workbooks to be data columns on the target sheet. (If that makes sense).