Creating a Profile sheet from a Markbook Vlookup

Hi everyone, I am trying to link a gradebook to a profile sheet (2 workbooks). I need to search a student name to then have it automatically input their results. I tried to simply do a Vlookup for the name in a cell search the workbook but I keep getting an error. It doesn't seem to matter if I change it to text, create an ISTEXT function or anything else, I keep getting no return.
I am trying to lookup the name entered into the profile sheet workbook under student name and search for the result in MS Markbook (ORIGINAL).
So if I entered James Bond into the profile sheet it would then prefill the SU result from the MS MARKBOOK, which is an A. But I am not getting that. I have tried a few different options which can be seen in the profile sheet, they are all searching for the same thing even though they are under different headings. If I can get one to work the rest will be the same but just different rows, but I can't even get one to work. any help is appreciated. Thank you.
MS Markbook (ORIGINAL).xlsm
Profile sheet.xlsx

@oeldere The reason I am doing it in a different workbook is because there will be multiple sheets (1 for each student) and it would make the markbook too awkward.
I tried to do the Vlookup in the same workbook and still got an error #N/A. I tried your code and still got an error #Name? I don't have any addittional spaces in the names, I checked that, I even tried typing the names rather than using concat.

@oeldere thank you that works. But I wonder why it doesn't work when I select the cells from A4:U11? I even tried doing it on the main workbook and it kept giving me an error.

@AliGW I didn't even think of creating a drop-down box with the students names that would be a great idea also, I'll add that in. Maybe that will just solve everything. Drop-down and on the master copy, just click and print. I'll give that a go and try just changing the column to hopefully be able to select everything else that I need.

@oeldere yea thank you I worked it out last night. I realised all I needed to do was switch the location of the names for it to work. I was like why does it work from here and not there. Thanks again.