Populating class lists from one master list

Good morning,

I have a master enrollment list for summer school. The students will have three choice and the will be filled in as they return their sheets. Each tab on the bottom is its own class.
I want to be able to automatically add the students and all of their information to each class list. So that the teachers will have all of the contact information on it. I have attached a sample workbook that has the master enrollment list on the first tab and the classes are the tabs after it.

I hope this is clear but i do not want to have to type each individual list.

Thanks in advance

If those are real names, phone numbers & email addresses; you might consider redacting your sheet. Identity theft is already too easy!!

I have removed your attachment, it looked like it contained sensitive info - never a good idea to post that on a public forum

If this was not sensitive info, then please repost. Otherwise change it to dummy data, then repost

Why not just filter on column I, J and K in the master enrollment

Hi there. I'm 1000 miles from home, with a limp wifi conection... So apologies if I'm a bit slow to respond!!If I were you, I wouldn't have numerous sheets. I'd have 3.

Select the class from the Drop down list in Classes (it's taking the class list in "Totals", using a named range [CTRL F3] and Data Validation, and the sheet autopopulates.

Any use to you?

You're welcome and thanks for the Reputation. If you run into any other problems, please shout...