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.