Excel Formula

So I have a gradebook and multiple sheets in the grade book for different categories. I would like to only enter students names once in a separate contact sheet. Can someone point me into the right f...