Say cell A1 has the data validation pull-down. Insert the following
worksheet code event:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub
Sheets(Target.Value).Activate
End Sub

After selecting a sheet name in cell A1, that sheet will automatically be
selected.
--
Gary''s Student - gsnu200771


"Destiney" wrote:

Is there a way when using a data validation list, to hyperlink the list
options to pages in the workbook? So for example, if you had a lot of
worksheets in one workbook, is there a way to choose a worksheet from the
list and have it go to the corresponding worksheet?


Thank you.