Copy a worksheet to another workbook in Excel 2007

When you have multiple workbooks and you feel that certain worksheets need to be placed in a workbook. For example, Book1 with worksheets Sheet11, Sheet12, Sheet13. Book2 with worksheets Sheet21, Sheet22, Sheet23. Book3 with worksheets Sheet31, Sheet32, Sheet33. You need to have a copy of worksheets Sheet11 from Book1 and Sheet22 from Book2 into the workbook Book3. Perform the following to do so:
1. Open all the workbooks (Book1, Book2, and Book3).
2. On the sheet tab bar of Book1, click the worksheet Sheet11.
3. Right-click the worksheet and click Move or Copy... to open the Move or Copy dialog box.

4. In the Move or Copy dialog box, click the To book: dropdown box and click Book3.xlsx. In the Before sheet: dropdown box, specify a location for the copied worksheet. For example, to place the worksheet at the end of the existing worksheets, click (move to end). To move to a location between two worksheets, say between Sheet22 and Sheet33, click the worksheet that is to the right, in this example, it is Sheet33.
5. Click to place a checkmark besides Create a copy.
6. Click OK.