Firstly I think that the code should go in an ordinary Module. In the VB Editor, Insert/Module and paste the code in there.
Right click one of the buttons, Assign Macro and choose your macro (probably the only one in the list). Right click the button again, select Copy. Then paste into each of the other sheets and delete the old buttons.