The best way to do this is to have the sum in the SAME cell on each
worksheet and then use this idea.

=sum(firstsheet : lastsheet!a1)

--
Don Guillett
SalesAid Software

"Stephanie" wrote in message
...
First, I have an excel document that I use for daily accounting. I use one
worksheet for each day. On each day I have several columns for various
products we sell. Is there a way to have a worksheet collect the data from
certain columns in each worksheet and total it? For example, I want to
know
how many products in category A I sold over the month. Can I have one
worksheet where it takes the data from the other 31 worksheets and totals
it?
I don't know how to arrange a formula to do that. Is it possible?