Run a command button using a different command button on different sheet

Current code:

Private Sub CommandButton2_Click() Dim cofCom As Object Set cofCom = Application.COMAddIns("SapExcelAddIn").Object Dim api As Object Set api = cofCom.GetPlugin("com.sap.epm.FPMXLClient") api.RefreshActiveWorkbook 

Now, at the end of this code, I would like to run the following buttons on the following sheets (different sheet than the sheet the above code is on). This simply allows the user to click one button and all queries update and all commands run for each tab... "one stop shop"

Sheet: Detail Y1

Commandbutton1 & commandbutton2

Sheet: Detail Y2

Commandbutton14 & commandbutton15

and so on...

I have tried various "Calls" or "Sheets" options and all are ending with debug.

Any ideas?