I am using INDIRECT to reference sheets that I will create in the future (Week 1, Week 2, Week 3...) I use IFERROR to hide the errors in the cells for future weeks where the sheet does not exist yet. The problem I'm running into is that the formula using INDIRECT does not recalculate unless I manually go in and edit it. The result is that even after I add a new sheet, the formula that references that sheet still throws an error as though the sheet does not exist.
I see some solutions for people adding new rows or columns, but I don't believe they will work for adding new sheets. I also saw the idea of using NOW in the formula, but I am concerned that this will affect performance, as I have 750 cells that are needing this fix.