Shift down content of range of row cells in Sheet 1 when new data is entered in Sheet 2.

[edge37]

Hello! Please help me out. I have a gradebook worksheet, where names and grades I assigned each appear. In another tab (Sheet 2) I have the list of names that appear in the gradebook (where I use the formula =Sheet2!A3 and down). If later I need to include a new student in a certain position, in Sheet 2 I would just copy the names that I want to shift down a space and paste them in position and then write the new name in the freed space of the list. Now, is there a way (formula) that in “Gradebook” the new name appears in the right position, all the other names down shift one space (as I did in Sheet 2), and also all the grades of those students shifted down in place with them (a range I can specify, in the image example I have only two different grades each)? I do not want to insert new rows in Gradebook, I just want the content of cells shift down accordingly. I include an image to illustrate my question. Thank you very much.

I hope I was clear enough.