The total on Summary matters while you edit inputs on Prep. With both sheets in the same Excel workbook, put 10 and 20 in Prep!B2:B3 and =SUM(Prep!B2:B3) in Summary!B2.
Pin the output before you switch sheets
Select Summary!B2, open Formulas → Watch Window, then choose Add watch. In the new row confirm the sheet, cell, value of 30, and formula. Resize the window if the formula is hard to read.

Illustrated starting watch. The address identifies the total even when another sheet is active.
Make one reversible input edit
Switch to Prep and change B2 from 10 to 12. Check that the watched address is still Summary!B2 and its value is 32. Restore the 10 and confirm the total is 30 again before deleting the watch.

Illustrated check. Only the first input changed.



