index Match to reformat data

Do you want the macro to work on all worksheets in your workbook?
No

Or, just a selection of some of the worksheets?
Yes

If so, what is the logic to just pick some of the worksheets?
still thinking about that one...lol

We could run the macro on all worksheets that begin with Tracker.
I could make this scenerio work and rename the worksheets to say "Trackerx", "Trackerxx", "Trackerxxx",etc.

Do you want the Final Format worksheet to include all the data from the other worksheets?
Trick Question: Well, Yes from all the worksheets that will start with Tracker

Will this macro, just pull the information once or will it duplicate the data if the macro is reran? Meaning today I run the macro, it will format the data, how it is currently being done. Tomorrow I rerun the macro the only difference is it will basically reset worksheet "Final Format", and give me the current information, correct? If so that would be brilliant.

Or will it duplicate the previous information, in addition to getting the current data? That would not be good.

Thanks for you help!