One way of many
=sheet2!a2
where a2 in sheet 2 has the total for the month.

--
Don Guillett Excel MVP
SalesAid Software

"chris quinn" <chris wrote in message
...
I am creating a yearly expense sheet with per month each page and a summary
sheet with monthly totals
How can I set it up so when results for monthly totals are created on the
month page they also appear on the yearly summary page?