David McRitchie wrote

Perhaps the example at
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm
might be helpful

I'll have a look.

I emailed an example based on sketchy details
you posted.

Sorry, I'll never get it. Address used here is bogus.

Don't know if all sheets have the same format, if a date is one day
or a semester. Don't know if all students take the same classes
that was my assumption; otherwise, the class report is not
going to work.

All sheets (pages in my single sheet scenario) have same format, dates
are all weekdays in month, students take same classes.

I think you might be able to do this with a couple of Pivot Tables
if the data is strictly

studentname, class, date

Data is set up as described in my last post. Just wasn't enough room to
show 25 date (C:AA) and 3 name/classname/total (A:B & AB) columns in a
post.

I left out 3 titles for ColA and 1 Total in ColB, though:
Page 1
This: SUM Monthly Student1 class time
should be
Total Class Hrs SUM Monthly Student1 class time

Same for Page 2

Page X
Add this after last item
Grand Total SUM all monthly class hours for all students

I know Pivot Tables can be powerful tools, based on all the suggestions
to use them in NG's, but every time I've tried to experiment, I get
totally lost and confused by the results, probably because test data is
from current files not suitable for Pivot Tables.

I think by now I've thought through this thoroughly enough to set things
up the way I need and maintain the integrity of the original file. One
change I'll make is to use SUBTOTAL formulas in place of current SUM
formulas in ColB.

--
David