Getting a macro to run on every workbook

[cologg]

Hi,
I'm hoping this is a stupid/easy question to answer.....

Every day I create a new Excel file with multiple sheets, and the sheets are always named differently. (They're the name of a horse race each day)

The output isn't as I originally wanted it so I have a very basic Macro to change each sheet but I have to run in on each sheet individually every day and I can't seem to get it to work on all sheets.

I've attached the Macro, a copy of the original output file and a copy of the new output after I run the macro on each sheet (results)

So the question is......is there a way to run that macro on every sheet without having to do it manually every time (on each sheet)

Thank you