It’s pretty common to change the names of worksheets, and today when I did that, none of the formulas that referenced the worksheet updated. I had to find and fix all the formulas to update the name of the worksheet within the formulas.
Agree, we’re tracking this as issue # 001703. WIll update this thread once we have it addressed.
This issue has been fixed as of the December 5th release. Now when a worksheet name changes, all cross-sheet formulas that reference the renamed worksheet update as expected.