Displaying the true text of Indirect formula

Hi,

I have created a dynamic calculation that creates named ranges, the names will change each time the calculation is run so I was unable to hardcode the named range. Therefore, the solution I have used is INDIRECT, however, I need to pass this spreadsheet onto someone who will need to view the formula is plain English. I know you can used form FORMULATEXT to display the formula but this doesn't show exactly what INDIRECT is doing. Is anyone able to give any advice? Example below.

Cell C2 (FronEndCalc) is creating the named range of JanToMar_LS using formula INDIRECT(B2&"_LS"), the named range of JanToMar_LS is in cell B1 on BackEndCalc), ideally I want the text of JanToMar_LS (the result of cell C2). Some of the calculation are very long but this example is a simple one.

Is this possible?

I have attached an example.

FYI - the named ranges get updated each time the calculation is re-run using VBA.

Thanks AliGW.

I wasn't sure it was at all possible, so my example was probably too simple. A more complex example would be with multiple INDIRECT.

I have updated my spreadsheet with rows 3 and 4 on the BackEndCalc and columns D and F/G on the FrontEndCalc, is the result in F or G possible?

I've tried using your example for the first solution but struggling to get it to work.

Really appreciate your help.

That's incredibly quick, thank you. They do get a little more complicated but with the two examples I should be able to figure it out.

Thanks very much.

I will mark as resolved and reputation added.

Thanks again