I want to either add a combo box or using data validation creat a list of
peolpes names. I will create a worksheet with each persons name and use the
result of the combo box or drop down list t navigate to the corresponding
worksheet.

How can I set this up?