I think add-in is definitely the way to go as well. Any idea how updating an add-in would work though?

The ultimate goal of this is to be able to update the template and the macros separately from each other but still have them work hand in hand for multiple users. I hoped that if I could somehow make this add-in like a bit of program where when the user opens it, it asks them to locate the template and so then all the linking works appropriately and then it installs a toolbar to their excel with the appropriate buttons for running this macro.

I definitely think this is possible, the only problem is, if I update the add-in and then send it out to everyone again, what will happen when they try to run it...will it create a duplicate of itself or just replace the current one?