workbook formula no longer carrying to the assigned pages

Hello

It seems i have exhausted all other options in the search for the answer to why all of a sudden the workbook I'm working in is not carrying the formulas to the allotted pages.

there is a master page. then there are named pages. all stopped working around the same line on mast page.

here is the formula for the date =IFERROR(INDEX(Master!$A$4:$K$279,SMALL(IF(Master!$B$4:$B$279=MID(CELL("filename",O1),FIND("]",CELL("filename",O1))+1,256),ROW(INDIRECT("$1:$"&COUNTA(Master!$A$4:$A$279)))),ROW(1:1)),COLUMN()),"")

This line is for the NAME of the sheet: =IFERROR(INDEX(Master!$A$4:$K$279,SMALL(IF(Master!$B$4:$B$279=MID(CELL("filename",P1),FIND("]",CELL("filename",P1))+1,256),ROW(INDIRECT("$1:$"&COUNTA(Master!$A$4:$A$279)))),ROW(1:1)),COLUMN()),"")

Below is screen shot of master page. And also see a screen shot of one of the named pages. As you can see the info has stopped carrying to named pages around sep 1 2023.

I am not able to find out why and I'd be grateful for any help!

Thank you!