I am making a program in excel for some time cards then workbook starts with
sheet one to change the date next sheet has the list of names with all the
info that needs to be put on the timesheet that lists all the names in
alphabetical order and the sheet that follow are the timecards i can get it
to put all the info itto the sheet but what i need to do is get the sheet
name tab to change to what the name from the list is so the tab names changes
as the list changes can someone help please.