Excel 2007 : How to create a loop that deletes worksheets

I run a macro that deletes worksheets. I have a repeating script that changes the name of the worksheet. The worksheet names are PDGroup1 PDGroup2, PDGroup3....etc, etc. How do I loop thru the same script but having it change the number at the end of PDGroup. Currently I have multiple scripts with the different PDGroup names.

Here is what I am currently using, but multiple times

Please Login or Register  to view this content.