My situation... I want to create a drop down list wherin the entries are
hyperlinked to their respective worksheets. ex: WS=worksheet

WS "Regional Directory" contains a cell where I want to create a drop-down
list.

"Deep South" specifically. I have created a list of all states that reside
in this region.

WS "Drop Down Lists". on this ws I hyperlinked the individual states to
their named worksheets. ie. "Alabama" hyperlinked to "WS Alabama". Named
this list "DeepSouth"

When I create the drop down on WS Regional Directory, using source
"=DeepSouth" It creates a non hyperlinked list which in text matches the
sourced list. However, the list entries within drop-down menu are not
hyperlinked. Which is what I need them to be.

Suggestions??