Copy worksheet by date

[mike]

I need to copy a worksheet from a workbook of about 12 worksheets.
Each worksheet is named the date it was created. No two worksheets
have the same date. I want to take the oldest and make it the current
worksheet, like a workbook that revolves. I want the oldest to be
renamed the current date (today()). How do you select the oldest
worksheet?

 

[Dave Miller]

What format are you dates on the sheet tabs?

 

[mike]

What format are you dates on the sheet tabs?

I can use any date format. Currently I use Name of day month year, ex:
Wendesday Apr 11, 2005, but ANY format will do.