Return multiple values from another sheet, based on a single criterion in the original sheet

[riverspree16]

I feel like I'm going around in circles between index and more. I have multiple sheets, but for this example just set up the two I needed as they would appear in my workbook. I am trying to make it so that if I select a student's name from a drop down in Column A on sheet 'Student Report' (first image) it will auto-populate the row values from the sheet 'AT MT' (second image). I've had no issues until column H - where I would like it to list an average of all their scores from another sheet. At this point, I've given up on getting the average, and would at least like it to list all the values found instead of just the first. In other words, I select "Jane Doe" in column A of 'Student Report' and it returns all the scores listed under "Jane Doe" on the sheet 'AT MT' For some reason if I am pulling those multiple found values from a location on the same sheet, it works fine. But once I try to point to the other sheet it no longer works.

Also, like 1000 virtual brownies if someone can also average it!

 

[Snakehips]

@riverspree16 Does this help?

Book1
	A	B	C	D	E	F	G	H
1	Student Name	Location	Grade	Skills	Learning Plan	Mastery	Attendance	Average Score
2	Jane Doe	Virginia	6	_	4	0.5	19	2.667
3	John Doe							1.500
4
Student Repoert

Cell Formulas
Range	Formula
H2:H4	H2	=IFERROR(AVERAGE(FILTER('AT MT'!$D$2:$D$1000,'AT MT'!$B$2:$B$1000=$A2)),"")

Book1
	A	B	C	D
1	Date	Student Name	Attendance	Student Score
2	7/1/22	Jane Doe	19	2
3	7/5/22	John Doe	19	1
4	7/6/22	Jane Doe	19	3
5	7/8/22	John Doe	19	2
6	7/11/22	Jane Doe	19	3
7
AT MT

 

[riverspree16]

It did thank you, I had tried similar formulas but now think there was an issue with the file itself. Have started a clean copy of the workbook and this is working wonderfully thank you so much for your assistance!