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...