Hi everyone
I managed to work around having a macro to change a macro by using the InputBox to directly change the values in the cells on the sheets instead. After not being able to work on it for a week and coming back to it with fresh eyes it made sense. The macro only needed a slight tweak and it solved my problem.
Thanks again to anyone who looked at this.