Running Macro Across Multiple Sheets

Hi,

I have a macro on the attached workbook that looks at one of the "Draft" sheets and runs the macro to look through the individual team tabs and returns what you see in Draft20 in Column F and G (if that player is in one of the tabs, that information from the tabs he's in).

In the past, I have just been manually moving each individual draft tab to the first tab in the workbook and then running the macro with the name of the sheet in it but is there some way I can just run all my draft tabs all at once?

Hopefully it's an easy solution.

(Skimmed down the draft tabs to comply with the rules of the forum)

Thanks for the help.

Without changing too much of your code, try the attached with updated "Draft" macro.

This will update all the sheets with the name "Draft" in them.

Try

Please Login or Register  to view this content.

Are you trying to do like this?
Order of the worksheets doesn't matter.

Please Login or Register  to view this content.