sheet 1 result - auto fill in to sheet 2 list

Hello everyone,

this are the testing format for my excel project
SHEET 1.png

from the sheet 1, i already key in all the data

but,

SHEET 2.png

how can i link example -
sheet1 a2 (student id), a3 (name), c13 (total mark), and g7,8,9,10,11 (grade) to auto fill in sheet2 according to columns line, but after it fill up to sheet2 the sheet1 will be empty and start for new student id,name,marks and grade

is it possible to do that formula?