How to lookup values from dropdown lists in Excel?

I have a complicated Excel worksheet, but I will simplify what I need in a simple scenario.

I have the following sheet as raw data.

Also, I have another sheet where I can select the student’s name from a list, lookup for the scores automatically, and calculate their percentage.

enter image description here

Now, I have a third sheet where I want to fill the percentages automatically from the second sheet.

enter image description here

I tried using the FILTER function but it fills the column for the selected student only.

enter image description here

I know there are easier solutions for this scenario, but my actual worksheet is much more complicated than this. I need to fill a column regardless of the selected value.