Hi,
I have asked this different ways before and have totally confused myself!
This is what i want to do:
Use a drop down menu (Combo box for example) to look at all the sheet names (these will be names of people, sheets added all the time) be able to select a name which when selected takes me to that sheet. So the amount of sheets will increase so everything will need to be dynamic.

Could anyone let me know the best way or provide an example?

many thanks in advance