Action Button Module Links

Hi,

I have several worksheets that I receive weekly that needs to be compiled into one workbook. These worksheets have the same template and vba coding, only the values are different. The problem I have is when I copy and past worksheets together, my command buttons lose the link to the module in which the macros are located even though the same macros exist in the new workbook under the same name and module. Is there a way to structure my coding so that I won't have to relink my command buttons every time I move my worksheets to a new workbook? Thanks in advance for the help.

Dan