If you have a value in a named cell in another sheet in the OSR workbook, and you are trying to collect that value into the OSR report sheet, you need to do the following:
If it is in another sheet you’ll have to give a reference to that sheet.
=INDIRECT(“Sheet!Cell”)
Where Sheet = name of the sheet you’re looking into.
Cell = Name of the cell you’re looking into.
If for example I want to reference to cell B5 in sheet2, then the formula would be
=INDIRECT(“Sheet2!B5”)
If you renamed the sheet2 to Test, and the cell b5 to Cell, then the formula would look like this
=INDIRECT(“Test!Cell”)
If the sheet you wish to refer to includes expanding groups, you have to rename the relevant cell, like shown above.