Need a Macro to search for text in sheet and copy the matching row to new sheet

Hi I am New to Excel macro scripting . I need your help to find do a task in excel which i am struggling till now .

I have excel in which sheet1 & sheet2 contents are as attached in excel

I want to script which reads the first column of sheet2 until the end of empty cell and then find each cell value against sheet1 and print all rows which has the value of cell to sheet3 . so as per the excel sheet attached say sheet2.A1=luke .I have to find for luke in sheet1 ,Now I find 2nd row and 3rd row has contents of luke and script has to copy the entire matched rows contents to sheet3 . next it has to take sheet2.A2 value "nick" and do the same find operation in sheet and copy the matched row1 and append it sheet3 contents.

Thanks in Advance.

Regards
Rob