Hi

assuming that your total row in each of the 12 sheets (and by sheets you
mean separate worksheets, not "printable" pages within a worksheet) is in
the same place (e.g. row 20), on the master sheet you can use a formula e.g.
=SUM(Jan:Dec!A20)
this will add up from the sheet called Jan to the sheet called Dec
everything that is in A20.
(substitute your sheet names for Jan & Dec (if your sheet names have a space
in them you'll have to use single apostraphe's around the names, e.g.
=SUM('Mth 1:Mth 12'!A20)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"MamaHart" wrote in message
...
I have an Excel spreadsheet that has pages 1-12, which is a two year budget
of items per category (there are 12 categories). I want to make a MASTER
sheet that includes the total row of each of the 12 sheets. How do I
populate the fields on the MASTER sheet from the other pages?