I have a set of worksheets (200) that all have the same name, and they all
need to be changed to a name that is in the same cell address. The sheet
names are all 4631 and in cell A2 in every sheet is the full name ex.
"4631-02-09"

I am wondering if there is a way a macro can do this?


Todd