Worksheet.Move (Excel)

Moves the sheet to another location in the workbook.

If you don't specify either Before or After, Microsoft Excel creates a new workbook that contains the moved sheet.

Move (Before, After)

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

Arguments

Optional arguments

The following arguments are optional

Before (Chart) - The sheet before which the moved sheet will be placed. You cannot specify Before if you specify After.

After (Chart) - The sheet after which the moved sheet will be placed. You cannot specify After if you specify Before.