My workbook contains several worksheets, say 20, each relating to the hours
of a specific department within my company. I want to total the hours across
all worksheets, i.e. sheet!D,cell D34 + sheet!E, cell D34 + sheet!F, cell
D34........etc. (There may be up to 400 such mini-totals that I need in my
"totals" worksheet.)

Anyone have any good ideas how to do this other than simply adding the
cells...is there a function/macro that'll do this?

Allan