Hey everyone - I don't really know how I would word this in a google search so I hope that you amazing wizards are able to help guide me in trying to better understand.

I built a sales pipeline management workbook that's pretty intricate with auto populating formulas and a whole bunch of custom macros blah blah blah. I've deployed it out to a few people who wanted to use it for their businesses and at least every couple of days I find a bug, and fix it, and move on with my life. But if I send a friend the newest version with the fixed bug, they have to manually copy and paste a bunch of data and some of them aren't super excel savvy and will most likely screw something up.

If I wanted to have a master copy where 1 worksheet out of the 5 that are in it is linked directly to their secondary copy, anytime I update code / formulas on the master, as long as they hit refresh it'll automatically update their code / formulas on their end.

Is something like this possible?

If not - is there a way to create an upload option in the workbook where they can upload the previous version into the new version and it auto updates specific criteria?

Thank you!