I am sure this can be done somehow but i looked around and couldn't find the
way...

I need to make timesheets for 12 people (which I will do each person as a
seperate excel file) but in each I need to have a tab for each week. The 7day
range is already preprogrammed in, I just need a tab made for each week for
the remainder of this year, and would like to do it without creating each tab
seperately.

Also, the 7 days are in cells I2 and I3 (labeled beginning and ending
respectively). Also the 7 days in the week have their own rows and columns,
cells C5-I5. These are already made to display the date for each day
correctly, by only changing the date in cell I2.

I can give more info if needed :)