Running Macro through multiple worksheets

I am attempting to utilize the same macro through out multiple worksheets without having to run it on every page. I found a similar thread on this topic but am having trouble getting mine to work.