Formula to pull out data from a list to create "Class Lists"

Good morning all,

I have a master list of enrollment for our summer school program and i was wondering if there was a way to automatically add each student to a class list as their information is inputted. What i mean is, after input Sally Student in the main enrollment list she would automatically go to the class list for the class she has chosen.

I have attached a sample workbook with my desired results. Basically what i want to do is make this easier for those in charge to get the class lists from the main list without having to copy and past all the time.

The class lists are in the tabs in the workbook.

These formulas are way above my pay grade so, any and all help would be greatly appreciated.

Thanks in advance.

Los

Thanks for the response, I know what you are trying to do but i cant seem to replicate it and get the desired results. Also some the classes are broken up by grades, would it be possible to look at the name of the class then the grade to create the lists?

Thanks again

Los

That is perfect thank you so much!!!!

Los