How can I retrieve a value of one cell in another sheet (within the same workbook)?

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.


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


If you renamed the sheet2 to Test, and the cell b5 to Cell, then the formula would look like this


If the sheet you wish to refer to includes expanding groups, you have to rename the relevant cell, like shown above.