Our bookkeepers have Excel Workbooks that have Numerous worksheets all labeled as
YYMMDD-JE-PG-1. 2. 3. etc. (where YYMMDD is the Year, Month, Day i.e. 150331)
There is a SETUP worksheet.
Each month they rename dozens of Tabs
My question, is there a batch method to rename the Tabs or
Can we key the name of the Tabs from a cell on the Setup worksheet
(Using Excel 2003)