I have a spreadsheet that has a list of high school students in a club, with their grades, club meetings they've attended, and service hours they've done each semester.

I currently have it sorted first by grade, and then alphabetically by last name within each grade. There are a lot of members who need to be added to the spreadsheet, and membership will continue to change as seniors graduate and freshmen come in. So is there a way that when I add a student, the list will automatically resort (by grade and name)?

Also, what would be the easiest way to add new students? This spreadsheet will be primarily edited by other people, who have little experience with excel. Perhaps some kind of data form?