not another tab but completely different spreadshee
You mean to a different workbooks(file).
keep the file to which you want the sheet is to be copied, open
right click the sheet stab. click "move or copy"
in the move or copy window check "create a copy" at the bottom
go the to the arrow at the top next to "to book" window.
your other file name will be there. click it
you will be asked where do you want to copy after sheet1 etc or at the end
and click ok