Taking a filepath name from a cell in VBA formula

[aaw23]

Hi, I am attempting to replace the hard typed filepath name in various formulas with the filepath as it appears in a cell.
For example rather than the below formula:
ActiveCell.FormulaR1C1 = _
"='I:\Finance\Reports\2022-2023\02 August 2022\[Consol Report Aug 22.xlsm]Retail'!R158C9"

being able to reference the file path as it is typed into another cell (say in cell C2 of ths sheet being worked in):

so that this file path name could be combined with the sheet name and cells in the formula.

Appreciate any assitance

 

[OaklandJim]

I tried to understand your need but from the description, you gave I was not able to. Maybe try again to describe what you are attempting to do.