Editing multiple cell Formulas to point to new sheet

[gd6noob]

Hi Excel Gurus.

I have 36 cells to update and each cell has formulas that points to a sheet, which will need to point to a new sheet.

Here is one of the cell formulas:

=COUNTIFS('Apr 15 - 21'!$D:$D,Summary!$K$12,'Apr 15 - 21'!$C:$C,Summary!$K$13,'Apr 15 - 21'!$E:$E,Summary!C2)+COUNTIFS('Apr 15 - 21'!$D:$D,Summary!$K$12,'Apr 15 - 21'!$C:$C,Summary!$L$13,'Apr 15 - 21'!$E:$E,Summary!C2)+COUNTIFS('Apr 15 - 21'!$D:$D,Summary!$K$12,'Apr 15 - 21'!$C:$C,Summary!$N$13,'Apr 15 - 21'!$E:$E,Summary!C2)+COUNTIFS('Apr 15 - 21'!$D:$D,Summary!$K$12,'Apr 15 - 21'!$C:$C,Summary!$M$13,'Apr 15 - 21'!D:D,Summary!C2)


It points to a worksheet dated "Apr 15 - 21" and each week I need to make a new worksheet. Everything will stay the same, just needs to find values for new worksheet, so in this case, "Apr 22 - 28"
Manually updating takes too long, I want to know if theres a way to change them all at once or a faster way?

 

[gd6noob]

Hi Guys,

I actually found the way.

Please disregard this post.
I cant see to delete it