I have a macro that assigns the Day and Date of the month to each tab (Thanks
to the folks on this board) but I would like it fill the corresponding day
and date in a cell on each worksheet. Any suggestions?

Also, on another workbook they would like to use the date of the tab as the
starting point in a series to assign a pickup number. ex. Tab is Thursday,
10-01. The number series would be 100101, 100102, 100103, etc. Then of
course, the next day would be Friday, 10-02 and the number series needs to be
100201, 100202, 100203, etc. Any suggestions on this??

Thanks!