Need series of listboxes to pick data from large list

Morning,

Here is my dilemma,

I have to create an excel program to go out and find information from a series of other workbooks so that if the program were stolen, the data would not be.

One of the features I would like to have in the program is a way to search through a workbook containing customer contact information and to find a specific company through a series of list boxes. Here is what I have:

The source book has a series of columns:

cust-id phone fax name city state email-addr

(There are no duplicate Cust-ID's but there are duplicates of cities in various rows as well as names. Data is found in B2:H4500)

I want to begin with a list box that has the three values Name, City, and Cust-ID in it to allow the individual viewing the workbook to sort through the list by that value

Next I need a listbox that contains all the names, cities, or Cust-IDs of the previously chosen category, I also need it alphabetized and duplicates to be removed if either Name or City was chosen from the list above.

Finally, if Cust-ID was chosen in the first list box, and a specific value chosen from the second text box, I need that ID #, the name and the city corresponding to it (all in the same row on the source document) to be displayed in some 3 cells on the worksheet. If, however, the value "City" or "Name" was chosen in the first listbox and a corresponding value in the next listbox I need a third list box to show only the Cust-ID's associated with that name (Cust-ID's are all unique). Once that ID # has been chosen I again need all three values ("Cust ID", "Name" and "City") to be displayed in some three cells somewhere on the document.


I'm not very good at VBA so if you develop a code to use this, if you could explain it to me on how to implement it that would be most helpful.

Thank you.

Does anyone have any ideas?