Move Method Example

This example moves Sheet1 after Sheet3 in the active workbook.

Worksheets("Sheet1").Move _
    after:=Worksheets("Sheet3")