data from sheet to sheet automatically

[LosLagosGC]

Is there a way for me to be able to get data that I input on one worksheet
automatically inserted into another worksheet...

Ex: I have a yearly budget with the monthly totals, And then I have the
monthly budgets with the weekly totals.

Can I get it to where when the weekly totals are added up for the month,
(Worksheet 1 monthly total) that the monthly total in that worksheet
automatically gets inserted into the monthly total on my yearly budget
(Worksheet 2 yearly total)?

 

[Pete_UK]

The easiest way is to select the cell where you want the value to
appear (the destination cell) and begin typing a formula - type = and
then click the sheet tab for that month, put the cursor in the cell
that you want to send the value from, and then press <Enter>. You will
have a formula that looks something like this:

='monthly total'!F25

Hope this helps.

Pete