Deleting a row of data based on a single cell deletion, and shifting remaining cell up.

I know that was a lot in the title. I'm relatively new to VB and macro's if that's what this requires.

I've got an excel file that totals up student points that they earn on a daily basis. The teachers manually input the data, the sheet totals it and decides based on the percentage whether the student qualifies for the quarterly celebration (Yes/No). There are four separate sheets (4 celebrations), and then a fifth sheet that takes the results from the first four sheets and tells me whether the student has been to all four celebrations. If so, the student qualifies for an extra award at the end of the year. The students' names and percentage data are linked between the pages.

Here's where I need help. We have students constantly enrolling and withdrawing. The teachers want to delete/add names to keep their name columns up to date but the data that is associated with their student's name remains on the sheet. For example, If they delete a student name and copy and past all the names up, the data for each student won't shift up with them.
Here is a screen shot of the sheet.

Thanks for the tip.

Here is the unprotected sheet. Sorry that wasn't because of you guys. It was protected to keep the teachers from messing up the formulas and formatting.