I have a master spreadsheet that I'm using to create and send forms to
different people. Once they receive the form, I want them to complete it and
send it back to me.

However when I do this, I'm copying the form from a blank template in one
file into a new book. The button on the new file still refers back to the
macro on the orginal file, not the Macro on New file. (I placed the macro on
the sheet itself) Is there a way to get around this? Or maybe move a module
from one book to another through a macro? Any help would be greatly
appreciated