|Let's start with the easy parts:|
First, you have plus signs in all your formulas. That's a throwback to ancient times and is not necessary. Save yourself some keystrokes and don't use them anymore.
Second, you said "I do have codes in cells A5 through A11."
The word "code" is usually reserved for VBA, like the "code" I offer below. It would probably be better (i.e. more easily understood) if you said "I do have formulas in cells A5 through A11."
As for naming your sheets, this Worksheet_Change macro will name the sheet based on the date entered in B3. The Sheet will be named as soon as the date is entered.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$3" Then
Me.Name = "Week Ending " _
& Day(Target) & " " _
& MonthName(Month(Target)) & " " _
Do you have some way of ensuring that the users enter a valid date in B3? Data Validation can take of that by simply using the Date option, but that won't ensure that they enter a valid week ending date. You can use Data Validation to take of that too, but it's a bit more complicated than just choosing the Date option.
Come on back if you'd like some help with that part.
BTW...You could also set it up so that the user only has to enter the week ending date in the first sheet and the other sheets could use a formula to place the other week ending dates in the other B3's.
The VBA code could then be modified so that it names all the sheets as soon as the date is entered in the first B3.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.