Moving Sheets

Moving an existing worksheet

The Copy and Move methods of the Worksheet object allow you to copy or move one or more worksheets in a single operation.
Both the methods have two optional parameters that allow you to specify the destination of the operation.
The destination can be either before or after a specified sheet.
If you do not use one of these parameters, the worksheet will be copied or moved to a new workbook.

Copy and Move do not return any value or reference.
The first sheet created by a Copy (or resulting from a Move) will be the immediatley active after the operation.

Worksheets(1).Move 

Sorting your worksheets into alphabetical order