How to copy row frm 1 sheet to another depending on the value

Hello,

I am a beginner to this area of VBA coding. I wanted to know how can i copy a row from 2nd sheet (Sheet2) to first sheet (Sheet1) depending on the value i enter in a cell in Sheet1.

Ex., If i have students details in Sheet2 as :-

Student Id Student Name Address
-----------------------------------------------
01 ABC Street 1
02 DEF Street2
03 GHI Street3




And i have a table in Sheet1 as :-


Student Id Student Name Address Status
--------------------------------------------------------------




So if i enter/select Student Id in Sheet1 from the drop down list, then it should take the 2nd & 3rd fields (Student Name and Address) data corresponding to that Student Id from Sheet2.

Anybody's help would really be appreciated here ..

Thanks in advance :-)