I have a worksheets each named for a week in the year. Within each worksheet
a person has a log entry for that week. I want people to be able to navigate
through the workbook using a combo box or list that hyperlinks to each
person's log entry for the specified week.

Right now I have hyperlinked the date under each person's name like this:

John Jane Jack
01-07 01-07 01-07
01-14 01-14 01-14
01-21 01-21 01-21

But it requires too much scrolling when you have 52 weeks, so I want to use
combo boxes that navigates based on the selected Person and Week. What is the
best way to do this?

Thanks,
Kate