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

do you wish to look for luke, nick and whatever else might reside in the first column of sheet2 in column "F" of the first row? Or should the search take place on the whole sheet? Are we looking for cells that have the exact same content or cells that have the searched phrase within them(like C2 = this is Luke testfile?

Search should happen on the whole sheet1 and the search phrase can be within the cell content like c2 "this is Luke testfile" .

I managed to write the macro on my own but the processing time is more since the records are more.

Is there a way I can find all the cell adresses for a matched string and set it to a range variable. ?

suppose If i can see the matched string on cell address A4,A10,A18 can I set a range to "A4,A10,A18" in the macro ? If so how do i set it and what is the syntax .Apologies if you cannot understand my question since i am new to macro terms.

Thanks in Advance!
Rob

Thanks Bishonen !

"FindNext" did the trick for me . It reduced the time of execution as well I was able to achieve what i was expecting .

Thanks a lot