Reference Custom or File Properties from an external workbook

I'm trying to reference a series of properties from one excel file to another. Ideally, I would like to have a search path or drop-down that would list out the various files that can be referenced from. I have the files set up to have the same property names (currently as custom properties) so that the reference files will always be overwriting the base file.

Any idea on how I can set this up?

Well... I'll answer my own thread I guess.

I referenced the other excel document property with the command: "='C:\xxxxx'!Property" and then managed the link by changing what the reference file was. I'm still in midst of creating a search path button to change what the reference document is, but as it sits now I am able to change the information in the 'data entry' spreadsheet and the then have it communicate with the 'analysis' spreadsheet.