Reordering Placement of Worksheet within group of Worksheets: Return to List

  Sheets("Combined GANTT").Move Before:=Sheets(1)' Moving it first (left-hand side)
  
Sheets(ActiveSheet.Name).Move After:=Sheets(Sheets.Count)' Moving it last

See also:
Activate Worksheet by Name
Activates the First Worksheet
Activates Last Worksheet
Adding a Worksheet
Copying one worksheet to another
Counting and Selecting Worksheets
Deletes Active Worksheet (no save)
Naming the active worksheet