Get data in listbox

[JackkG]

Hi All,


Sheet1
Name CID PID RefID Frequency
John J C1001 P001 R001 2
James H H1002 P005 R005 1
Mike J J1009 P009 R009 2

Sheet2
Name CID PID RefID Frequency
John J C1001 P001 R001 1
John J C1001 P001 R001 1
James H H1002 P005 R005 1
Mike J J1009 P009 R009 1
Mike J J1009 P009 R009 1


When I click on the name in Sheet1, let say John J, when i click on cell A2, I want to pull the data relating to John J in the list box, the data displayed in the list box will be from Sheet2, i.e., row A2 and A3 of Sheet2. Is there any way to this. Any help from anyone will be appreciated.


Thanks.
Jack