I have several excel files which are all identical in what they do but
all contain different data (each one is a different year) and they
have to remain separate files. Using a script in a module it populates
each sheet. Works great but the problem is that the modules in all of
the files are identical and whenever i need to change the code, i have
to go into each file and copy/paste the new code in. To run the code
each sheet has a button which activated Sub Populate() in the code. Is
there a way for me to put the code into a separate file in a different
location so that the can all share the same code?

Thanks!