Ordering sheets
In Excel there are two ways of changing the order of the sheets in your workbook. You can move a single sheet at a time by dragging the tab to a new position, or by right-clicking on the tab and selecting Move or Copy.... Both methods are frustrating if you are trying to reorganise a workboook containing many sheets.
The XLSior > Operate on Sheets > Order Sheets command displays a list of the sheets in your workbook.
You can change the order of the sheets in the list by using the buttons to the left: select a sheet and move it up or down, or to the top or bottom of the list. Click OK when you have finished, and the sheets in your workbook will be put in the order you have selected. The the list of sheets on sheet X~Sheets will be updated and displayed.