When you right click on the 'next or previous' sheet arrows a list of sheet
names appears which enables the user to jump to a specific sheet or if
there's a large amount of sheets then you have the option to view 'more
sheets...'

The dialog box that appears has the title of Activate, but there isn't a
xlDialog called Activate.

Can you tell me what it's called, or the code to actually show it?

Thanks