So let's say on Sheet 2, I have the user select the plant. I want it to update things on Sheet 3, Sheet 4, and Sheet 5 (tabs). If I understand correctly, I put that macro (Private Sub etc) on Sheet 2, and have it call up the macros that update the other three sheets. On THOSE macros, I need it to go to those sheets then run the macro (right now, the macro doesn't tell it to go to another sheet because the button is on that sheet).

Assuming the above is correct, can I have multiple Call NameOfMacro lines right after each other for the three sheet updating macros?