Creating Marco for varying number of sheets

[Roseline]

Hi.

I have an excel file which contains a few sheets named Sheet1, Sheet2, …., also include AA, BB, CC and DD( As a renamed Sheets). Sheet1, Sheet2, … SheetN, will have data pulled from another source.

I have created a macro, which formats the data on Sheets1, Sheet2, .......SheetN, "Individually" as per my requirement.

FYI…”sometimes”, there might be Sheet3, Sheet4, Sheet5 or more sheets of data pulled from another source.

But my challenge is:

1) When I click on created Marco button, data on Sheet1, Sheet2, …. SheetN, Etc. should be formatted "At the same time". But the rename sheets AA, BB, CC and DD should not be impacted, because AA, BB, CC and DD contain a different macro.

2) Also, (like I mentioned in the beginning), user might add several sheets like Sheet3, Sheet4, …SheetN, but AA, BB, CC and DD will remain untouched.

As a result, the macro that I am looking for should be able to accommodate how many ever sheets (Sheet1, Sheet2, Sheet3, Sheet4….SheetN) the user adds.

Can someone help/advise me on this?

Any help is much appreciated.