move the second worksheet to end of workbook
Sub SimpleWorksheetMovement() ThisWorkbook.Worksheets(2).Move after:=ThisWorkbook.Worksheets(ThisWorkbook.Worksheets.Count) End Sub