Thanks for the reply Pierre!

I can't have a single sheet, as each sheet will be used as a timesheet for each employee and sent to our accounting department. I like your idea for the dynamic range, I forgot that Excel had that feature; the next question is what would be the correct macro or VBA coding to apply the additional sheets to the dynamic range? I also see the need to have the worksheet names (on the tab) auto-populate to the dynamic range, so that if a user changes the text on the tab, the dynamic range stays intact.

Making progress, progress is good! Thanks for everyone that has looked, and thank you Pierre!