Lookup Data from Closed Workbook, Multiple Files

[SteelSkeleton]

I am trying to get some help with a excel macro for exporting data from a closed file and importing into a summery file.

I envision the summary file looking something like the below Structure with Folder and File Name listed and then cell reference names (from the "Name Manager") in the column headings.

File Path File Name NOI NCF
S:\Public\Knowledge Library k001.xlsx Results Results
S:\Public\Knowledge Library k002.xlsx Results Results
S:\Public\Knowledge Library k003.xlsx Results Results
S:\Public\Knowledge Library k004.xlsx Results Results
S:\Public\Knowledge Library k005.xlsx Results Results

Each file with data that is being looked up will have cells named "NCF", "NOI" ect..

Is this possbile to do? If someone could help me out with the code, I'd real appreciate it. Thanks in advance.