Hi All,

I would really appreciate some help with the following:

The first sheet in my workbook is called "Control".
The second sheet is called "A"
The last sheet is called "B"
In between sheets "A" and "B" are additional worksheets, one for
everyday of a month for example May 1 through to May 31.
On the "Control" worksheet I have starting in cell A2 the date
May 1 followed by May 2 etc.

What I need is some VBA code that will allow me to rename
all the worksheets that are in-between the "A" and "B" worksheets
with the list of dates that appear on the "Control" worksheet.

In essence as the user enters a new date for example June 1 in
A2 on the Control worksheet and drags the date down the column until it
reaches June 30,
all the sheets between "A" and "B" need to be updated.

Any ideas or suggestions on how to accomplish the above?

Thanks,

Steve