I have a time tracking workbook, with 20 time tracking spreadsheets. One for
each employee. I am using a sheet tab naming convention of (week ending
date-Lastname) i.e. WE-DEC-30-Smith. Can I create a variable for week ending
date that I can feed to the tab name from a list of names I have in an
admistrative worksheet at the beginning of the workbook? Otherwise, I have to
manually rename each of the 20 tabs for every week.