Macro running on all workbooks

First. I’m really not an Excel expert so please explain things slowly.

I regularly download a report that has a lot of raw data. I need to rearrange and rename columns and delete others that aren’t pertinent to my task.

I tried creating a macro to help with this. I simply clicked record macro, saved it in a new workbook, made the formatting changes, end recording.

When I went to run the macro I find it’s changing the formatting of other workbooks I have open as well. Obviously that creates a huge problem.

Question:

How do I create a macro that I can save on my computer and share with others so the formatting of this report can be quick and easy?