From The Document Foundation Wiki
    < Faq‎ | Calc

    How to change the order of individual sheets in the spreadsheet

    Follow these steps :

    1. Select the sheet which you want to move.
    2. With the mouse positioned on the tab of the sheet, right-click to access the contextual menu and choose Move/Copy Sheet.
    3. In the dialog that appears, make sure that the Copy option at the top of the dialog is not checked.
    4. In the list Insert before, select the desired position.
    5. Click OK.

    Another technique is to click on the tab and drag it to the desired position among the other tabs.