I wrote a small add-in that lets you switch between worksheets easily. Just download the installer and run the .EXE file, the add-in will be installed for you.
Sheet Picker Add-In – Excel 2000-2003 version
Sheet Picker Add-In – Excel 2007 version
Sheet Picker Add-In – Excel 2010 version
When installed, a menu item on the Windows menu called "Sheet Picker" is added (a separate Ribbon tab is added for Excel 2007 and up). A form with a list of all the available worksheets appears. Just pick one and click "Go To Sheet" to switch to that sheet. The "Exit" button shuts down the form. It's pretty primitive so let me know if there are any bugs.
See you at the Excel User Conference!
–JP
About JP
Follow Me