How to Copy Multiple Worksheets into One Workbook (Excel 2010, 2007 & 2003)
Instead of using the Copy and Paste function to copy worksheets into a new workbook, you can use the "Move and Copy" function to simplify the process. This can be a great time saving shortcut. This works the same in Excel 2010, Excel 2007 and Excel 2003.