Take a look at using 3d references in the XL help file. Perhaps something
like:
=SUM('Jan:May'!A2)

--
Best Regards,

Luke M
"T" wrote in message
...
I have seperate spreadsheets, one with monthly numbers and one with yearly
numbers. how would I go about updating a clients info in the monthly
spreadsheet and getting it to update in the yearly spreadsheet without
having
to go in and manually copy/paste?