I'm not exactly sure how to do this but think it must be a macro, which are the final excel frontier for me so I'm out of my depth. I have a covertab in a workbook with the names of ~75 employees in, let's say, A2:A76. I need to create a separate tab for each individual in the list. This tab is the individual's timesheet and would (ideally) be renamed as the individual or as his/her employee ID. Is this possible? I need to do it for all 26 pay periods and each employee roster changes. Please please help. Thank you in advance.