Compiling multiple ranges of cells from multiple sheets into one grand table ?

Forgive me if this topic is in the wrong place.
The reason I posted here is because I've gotten so much help from you guys on creating the userform my fellow teachers and I use to input scores...
Now I can't figure out how to compile these scores into the master sheet we look at once a week. At the moment I'm literally filling in the master sheet with "=sheet1!AA101" "=sheet2!AA101" and so on and so on... It's quite tedious ! There must be an easier way.

I'm guess it would require a 2nd userform ?

Any input on this is greatly appreciated !!!

Hi

If the sheets are all set up in the same format, you can create a front sheet (a blank userform), and then on that sheet use a grouped formula
=SUM('sheet1:sheet200'!AA101)
you can manually type it, or if you go tothe specific cell on the new grand total sheet, and start your sum,
=sum( then select the first worksheet, and the very end worksheet, whilst holding shift, then select the cell AA101, it will then total all worksheet for that one specific cell.
The only thing to be aware of, is that it will only sum the sheets between the two specified.

Adi

adi, thanks for your input !

the way it is set up now is that each student has their own spreadsheet. i have all the equations set to go such that at the end of each week i am able to get a score for each class (about 6) and then their total weighted average for the week. each of these scores then goes into a 'master' table where the column is each class and the rows are each student. i'm not summing across anything at this point, it's just getting the scores from a bunch of different sheets to one master sheet. to make matters a little more complicated, not all students are taking the same number of classes...