Can anyone share idea(s) for code that will programatically loop
through all the .xls files (each file has 10 worksheets) in a
directory and

1) delete the same four worksheets ("Sheet1", "Sheet10", "Sheet3", &
"Sheet6" from each of the .xls files, and then
3) change the worksheet Name property of the remaining six worksheets
so that the worksheet Name property of the first worksheet is
"Sheet1", the second worksheet is "Sheet2", etc.

Any ideas are greatly appreciated.