Allows you to move or copy sheets around a workbook or to a new one. This presents a dialog (Shown left), from which you can choose any open workbook in the 'To book:' drop-down or a new one and check the checkbox to make a copy. If you leave this unchecked, like cut and paste the sheet will be 'moved' to the new location. By selecting in the 'Before sheet' list box, you can accurately position the new move/copy. The copied sheet, if it remains in the current workbook, cannot have the same name so Excel appends a number such a (1) after the sheet name to make them unique.

Sub MoveSheet()
'moves it...does not create a copy
Worksheets("Sheet1").Move After:=Worksheets("Sheet2")
End Sub