Question: how to move a sheet from one workbook to another in excel 2007?
Answer: Copy Worksheet in Excel 2007 & 2010 First open the workbook with the sheet you want to copy, right-click on the sheet tab and select Move or Copy. Make sure you have the workbook(s) that you want to copy the sheet into open for them to show up in the “To book” dropdown list, then choose the one to copy to.