You want to create a situation so that you can monitor the results of cell formulas on a different..
You nonproduction to beget a condition so that you can warner the results of cell formulas on a irrelative worksheet as you veer facts on another worksheet. You should beget a:
(a) Facts validation window
(b) Hyperlink among worksheets
(c) Watch Window
(d) Circular Reference Window