How to 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.

=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.