How to: Move Worksheets Within Workbooks
Some code examples in this topic use the this or Me keyword or the
Themethod works much like the method in Microsoft Office Excel 2003, except that you end up with only one instance of the sheet. If you do not specify a location for the moved sheet, Excel creates a new workbook to contain it.
To move a worksheet
Assign the total number of sheets in the workbook to a variable and then move the first worksheet so that it becomes the last one.
If you want to sort the list of sheets in a workbook, you can make use of the Move method to perform a bubble sort.