After the last FY24 data has been entered on B and sheets A, C, and D have the final numbers:
- On sheet A, select all the cells that contain the FY24 data.
- Click on Copy on the Home tab or type Ctrl-C
- Click on the arrow to open the Paste sub-menu and select the first Paste Values icon, or type Alt-E->S->V->Enter, to replace the formulas with the computed values.
- Repeat for sheets C and D.
The cells will no longer contain formulas so the values will not change when sheet B changes.