Summary attendance sheet across many rosters

[DebbieDoesData]

Hi everyone,
I am new to the forum and while I enjoy using excel, I am still very much a novice. I would truly appreciate some help designing a summary attendance sheet that would pull information from across sheets of individual classes.

Here is what ideally I would need for it to do.
As people register for classes, they would be input into the class roster. Their attendance hours are tracked each individual date for each class and I can find out their total hours for each class.

I would like for there to be a summary sheet, that automatically populates the participants' names into the summary sheet and then tells me the total hours of participation, and finally, would highlight the participants (Conditional formatting) once the participant reaches 50 hours and above.

My difficulty is with having the participants listed in the summary sheet because participants are signed up for any number of classes. Some may only be taking one class, while others may be in multiple classes, so I do not want the participants to be listed multiple times, rather listed once, and then having the attendance from each class calculated as their total hours on the summary page.

I am attaching my spreadsheet. I may need you to explain it to me like I am a 5 year old, but I would be very grateful for any assistance. Any help is greatly appreciated! Additionally, if anyone has recommendations on these kinds of tutorials, feel free to point me in that direction. I am a novice but am looking to expand my knowledge in any way.

-Debbie

[mehmetcik]

Hi Debbie

This is interesting so I will help you here.

we could be lazy and just do what you ask.

Or we could go all out and produce a tool that will save you lots of time every day.

I will knock up some thing now and we can develop it as you like.

[mehmetcik]

Ok

I need to know how many hours to assign for each class and how that will be stored, before I can look at completing the Save Routine.