Excel doesn't allow you to do this.

You can see them or hide them.  That's about it.

You don't.

You can right-click on the sheet navigation arrows and select from 15 sheets or
"more sheets".

Or you can  build a Navigation Toolbar as per Dave's code on Debra Dalgleish's
site.

http://www.contextures.on.ca/xlToolbar01.html

Or see this google search thread for the BrowseSheets macro from Bob Phillips.

http://tinyurl.com/yoa3dw

Gord Dibben  MS Excel MVP