copy macros to another tab
 

I have a form with several macros on a single tab in an Excel XP worksheet.
Each time the user has an update to this form, they are to add a new
worksheet tab and copy the form from the original tab. is there a way to
copy the macros that automate the form to the new tab? (when I just copy
them, the cell references within are copied so that the macros are applied to
the original sheet instead of the new sheet)