|These directions assume you have Office 2007 or 2010. I believe Office 2013 is different and I know for sure Office 2003 is different.|
Open destination workbook (both workbooks will need to be open in the same Excel window)
In source workbook, right click on tab you want to copy from and select Move or Copy ...
In the To Book window, select the name of the destination workbook, and Select the tab in the destination workbook to insert Before
Click OK, which moves tab from source workbook to destination workbook
Close source workbook without saving (this keeps the original workbook intact without changes)
On the Data tab, in the Connections Group, click 'Edits Links.'
Click on Change Source, then browse for the destination file (the one that is opened) and click ok.
If you need directions for other versions of office, let me konw.