Autocomplete Using Dropdown List

What I want to do is click a vendor from a drop down list. When the vendor is selected, I would like the following to auto complete in their appropriate blank cells: street address, city/state/zip, phone and fax.

I have set up my page to the look I want as sheet 1. Sheet 2 is the list of vendors being column A is the names that are indicated in my drop-down list.

Column D is the street address, Column H is the city/state/zip, column M is the phone and Column Q is the fax.