Copy and Paste from Other XL file only Particular row items.

Hi Team,
Good Morning
I m New to this forum this is my first ad.
I need help , I am new to VBA, I am facing a problem to solve the below query.
In our school there is a marks sheet of entire academic year of all the students ( Master file ), I have another file to view the particular student all type of marks details, suppose if I enter the student register number, it needs to Display in my view file entire marks status including Test 1 and Mid Term Exam of particular student.
Please help me
PFA attachment of sample data
Thanks Kumar PK

Unable to upload the sample data , Please help I m trying to upload but its not uploading.Kindly mention your email ID so I can send directly.Thanks Kumar PK