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.

The watch identifies Summary!B2, value 30 and the SUM of two cells on Prep.

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.

The example watch shows 32 after Prep!B2 changes to 12.

Illustrated check. Only the first input changed.

Microsoft Excel instructions