VBA Assistance in Making a button to click all buttons thoughout a workbook

Hi

I currently have a workbook with at least one button on most worksheets. The code behind each button is a normal sub (not private nor public and most use option explicit) and does not reference the individual worksheet except where it needs to pull data from other sheets in the course of carrying out calculations.

I am now content that I can't progress the spreadsheet much further and would like to create a single button on the first sheet (which is actually sheet2 and has a seperate tab name "Last4") to trawl the other worksheets and click each button to update the workbooks.

I appreciate this isn't the cleanest method but I'm looking at minimum time coding maximum time saving.

The button I have created works fine whilst the master button is located on the first worksheet, but breaks before getting to further worksheets....any ideas??