You don't give too much information, do you ?
If all the totals have the same cell address in each WB, try this for
example, assuming totals are in cell A1:
=SUM(First:Last!A1)
Replace First and Last with the names of the sheets that you wish to include
in the total.
An important thing to remember, is that the *position* of the sheet tabs in
the WB designate the range to be calculated, *not* the sheet name itself.
In this case, *all* sheets between First and Last, including First and Last,
will be totaled.
Move a sheet in front of First or after Last, and it is removed from the
calculation.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
