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.