Copying or moving sheets between workbooks

Hi

Is there anyway to copy or move sheets between work books, so that the sheets you are moving will replace the existing ones. The sheets in the two workbooks have the same names, but each time I try and move or copy them, excel just adds them to the existing workbook with a (2) suffix to the name, but I want the new sheets to actually replace the old ones.

Can this be done?

Thanks.

Not without macros. All you need to do is delete the old sheet first and then move or copy the new one. If it's your only sheet, then instead of deleting it, change the name before putting in the new one.

ChemistB