Right-click the worksheet tab you want to move or copy and select Move or Copy from the shortcut menu.
In the Move or Copy dialog box, click the To Book drop-down list and select the workbook to which you want to move or copy the worksheet.
In the Before Sheet list, click the name of the worksheet in front of which you want the moved or copied worksheet to be placed or choose (Move to End).
Click the Create a Copy check box to copy the worksheet instead of moving it. If you want to move the worksheet, leave it unchecked. Then, click OK.
INTRODUCTION
When Excel inserts a new worksheet, it always places it in front of the currently selected worksheet. If you aren't in the correct worksheet tab before you insert the worksheet, however, you can simply move the worksheet to the desired location. In addition, Excel understands that many times data in one worksheet can be used as a starting point in new worksheets and even other workbooks (or perhaps you need multiple sets of data); for this reason, it enables you to copy a worksheet.
TIP
Moving a Worksheet by Dragging
You can click a worksheet tab and drag it in front of or behind another worksheet tab to change its location. This is a lot faster if you need to rearrange your worksheets.