Link spreadsheets to auto populate class rosters from master registration

Hi, I am new to the forum and just a casual user of excel. I am trying to link fields from a master registration sheet to auto populate class rosters once I paste in data and assign the classes. I have tried searching online, but can't seem to find the best way to get this done. I have attached an example of what I am trying to do.

Thanks.