If all the sheets to be included the formulaare in are in a row, you could
use a formula like this:
=SUM('Your first sheet name:You thirty-first sheet name'!cell_with_difference)
The single quotations are only necessary if your sheet names contain spaces.

Example, if the difference is in cell A3, and the sheet names are the
defaults:
=SUM(Sheet1:Sheet31!A3)

tj

"Excel'ed Failures" wrote:

Hello,

Currently I am working on a project that shows the -/+ of parts made by
certain departments in our facility. For example Department's "A" target was
10 and they only made 5 so they would be -5. This is done for 6 departments
and is recorded on 31 diffrent tabs (for every day of the month) on the same
worksheet. My question is that I would like to use a 3-D reference showing
the running total of -/+ actual achievements. Is there a easier way of than
typing in the formula for all 31 tabs? Typing in that tab 2 looks at tab's
1's data and tab 3 looks at 2's 31 times seems like I am doing this the long
way! Thanks in advance!