Can anyone help me with a code that will highlight selected item in a listbox on a worksheet?

I have a listbox that searches for an employee name through out the entire workbook and populates the worksheet names where the employee resides.

eg Andall Henry Sheet 1
Andall Henry Sheet 2

I want a code that will highlight the row in the specified sheet andall's name resides when select either Andall Henry sheet 1 or Andall Henry Shee2

Can anyone help me?