Multiiple Worksheet Loop Macro only Looping on 1 sheet

Good Morning,

I have a Macro which calls 2 submacros to create and names multiple worksheets. This portion is working. Additionally, I have 2 sub Macros that I want to process through all the worksheets in the file (one is for sorting and subtotaling and one for print formatting). Unfortunately, the Looping macro I am using is looping the same
worksheet data over and over instead of one time for each worksheet. Since the number of spreadsheets will be variable from file to file, I can't just define the spreadsheets once. Can someone help me with the correct code so that the Sub macros for Sorting&Subtotaling and Print formatting will work on any number of worksheets?

Thank you in advance!
LC

---------------------------------------------------------------

Please Login or Register  to view this content.

Moderator Edit:

Welcome to the forum, lscarstens.

Please notice that code tags have been added to your post. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.

This is the second time in 2 days that you've been reminded.
Thanks.

Hi, LC,

please use Code-tags to make your code worth looking at.

You stay on the very same sheet throughout your macro,maybe change it like

Please Login or Register  to view this content.

I would avoid the Activate and pass a parameter (in this case the index of the worksheet) to the procedures.

Ciao,
Holger