I have a complicated task ahead of me to create a "Work Order" work book that fills in many things using Drop Down Lists. I need to fill in the following information based upon the selections in drop down lists. Here is how it needs to work.

1) Select a "Customer" from a Drop Down List that will fill in 4 different cells for their Name, Street address, City & Zip and main Phone Number. I need up to 250 different "Customers".

2 ) Select a "Contact" from a Drop Down List that is linked to the particular "Customer" that will fill in 2 different cells for their Name and Cell Phone Number. I need up to 6 different "Contacts".

3) Select a "Machine Mfg." from a Drop Down List that is linked to the particular "Customer" that will fill in 1 cell. I need up to 10 "Machine Mfg.".

4) Select a "Machine Model " from a Drop Down List that is linked to the particular Customers "Machine Mfg." that will fill in 1 cell. I need up to 10 "Machine Model #".

5) Select a "Machine Serial #" from a Drop Down List that is linked to the particular Customers "Machine Model #" that will fill in 2 different cells for the Serial # and Control Type. I need up to 15 "Machine Serial #/Control Types.

I was hoping to be able to "Add" along the way up to the 250 new customers and be able to sort descending A to Z so the "Customer" Drop down list shows them in Alphabetical order with all the above info following the Customer Name. Can this be done with some kind of template to add all the information as new Customers are added? Will I need to use two separate Workbooks, one for the Work Order and one for the Customer Data?