MS Excel : Use combo box to load data from one sheet to another

[SDK^]

Hi,

I'm wondering if anyone can help me with the following Excel problem please.

In one sheet I have a list of ID, customers name, phone #, address, etc. Each row has a different customer with seperate columns for name, phone, address etc.
I would like to create a combo box that can be used to select the ID and then load their information into different cells on a different sheet.

Any ideas would be appreciated

Thanks