Hi!

I am a teacher and grade tests using excel.  I have a master template
of my MC test scoring sheet and copy a worksheet for each student and
input their data.

Once all their answers are inputted, formulas spit out their raw score
and percentile, as well as their percentile on all of the tested
subject areas of the test (if we were taking a math class for example,
it would give students their percentile rank separately for addition
problems, subtraction problems and so on).

The problem I'm having is created a non-time intensive class summary
worksheet.  I'd like to have an easy way to have the data from each
individual students worksheet automatically link to a score analysis
worksheet, so I can see what the entire class' scores are (also I'd be
able to average scores and find the high and low scores, etc) as well
as analyze what particular subject areas are causing students the most
trouble.

Right now, I do it the hard way [='John Doe!'$A$47], which requires me
to type out the student's name (which is the name of their worksheet)
for every field I want to compile.

There has got to be a faster way, right?  I'm sure there is some
complicating programming/macro way, but I'm wondering if there is some
variation of Names or 3D References or even Shift selecting all the
student worksheet tabs that would do the trick.

Thanks in advance for your help!

Jaime