I need to dynamically rename the Worksheet names, from a cell value in another worksheet.
The name’s source is from: Sheet4
The worksheets to change are Sheet1, Sheet2, and Sheet3
The value of the name, in it’s cell is a date, and is formatted as m/d/yyyy (10/1/2014)
The worksheet name...