Multiple hyperlinks from drop down list

Hi everyone,

I am an excel beginner and this is my first time posting on this site.
I have no experience with macros, and am only just starting to learn
the ropes of other basic functions.

Currently I have multiple worksheets set up. I want to create a drop
down box in a work*** that has 5 car dealership names. From this
drop down box i want to be able to click on each one of these names and
have each one be a separate link to a different spot on a different
work***.

Specifically:

I have a work*** called "Brand Names". On this work*** i want to
create a drop down box that has the name of 5 car dealerships. When I
click on one of these dealerships (say markville chevrolet), i want it
to take me to the section Markville Chevrolet I have created in a
separate work***, "Individual Dealer". I need all of the links to go
to this individual dealer ***, but land at different cell references
within the ***.

Any help would be greatly appreciated,
THANKS ALOT

lauren

.