Combine two reports accordingly

Thank you everyone for your help, i recently joined, and i am seeking some help. I have attached a file here .. I am trying to create one report from two reports. Two sheets, two reports. both sheets have same students but different information about them, but there are other students as well that may not exist in one of the two reports. I would like the vba to take a student (username) from sheet 2 (Report_1) find it in sheet 1 (main report) if there, copy both rows into a third sheet (expected result) and so on. So the expected result is username, his/her information from both sheets.

So we have the main report that includes students and some info about them and we have report 1, the second sheet, that has students and other info. the two report have students in common and a unique user name, that is how we can join the two reports. the third sheet is the expected result. Note that the header is copied as well. Thank you very much again, I am looking forward to your ideas. I was thinking about Vlookup!

PS. also,how do you use Vlookup to get multiple columns in this case? look for the student in sheet one, if there get me multiple columns from sheet two, put it all in sheet three Thank you very much again?

Thank you very much again.