Dynamic highlighting of rows

Hello,

I have a list of 200 names in sheet 1 and in sheet 2 i have more than 5000 plus names, with all the details like adress, phone number ,etc.

Now i want to write a macro, which when run looks at the names in sheet 1 goes to sheet 2 and higlights that row where that particular name exists. since I use it every week with many names adding and leaving i want it to be dynamic.

eg. :-
1 . sheet 1 has the name Raj.
2. I go to sheet 2 look for name Raj and make the entire row with data bold. similarly i have 200 Plus names.

can any one help me. I recorded the macro for this but its not dynamic.

thanks in advance

Raj