Lookup Value based off Data Validation List / Populate Form

Hello,

I am working on a gradebook for a teacher and am running into a little problem.

I am trying to make filling out an interim a little easier by having a validation list of the student names and populating different cells with the various grade by subject.

I have attached the sheet.

I have the Interim on the last tab in the sheet.
I have the validation list in A9, which pulls the names from the TOTALS tab.
Once the name is selected from the validation list I want to pull the grades from the TOTALS tab and place them in cells D44:D48 as seen on the interim.

I would imagine it would be a combination of INDIRECT and VLOOKUP but I don't quite get how to get this to work.

Any help would be greatly appreciated.

Mike