Using Cell Values in Active Sheet to Populate Path to External Reference Link

[wowcrofty]

I have a sheet within a workbook which I would like to pull data from cells in another sheet which resides in another workbook. The formula to do this I have figured out, but instead of using a fixed path, I would like to use data from cells within the active sheet to populate the file path to the external sheet. Please advise on how I would be able to do this. Any way without using VBA would be preferred; however, I am fairly familiar with VB, so a programmatic approach is fine as well. Thank you in advance for any assistance.

 

[AlphaFrog]

This link may help.

Excel “Pull” Function: Creating dynamic links to closed workbooks

 

[wowcrofty]

Thank you very much! That worked out perfectly. In fact, I feel that is a function that should come with Excel out of the box.

 

[AlphaFrog]

You're welcome.

There's lots of things that could be included in "the box".