I have an excel workbook with 5 sheets.
I have my data on sheet1.
i have used multiple indirect to get data to sheet2 from sheet1.
Similarly Sheet3 is getting data from sheet2 using multiple indirect.
And finally sheet4 is getting data from sheet3.

If I insert a new row in sheet1, it keeps running and does not respond.
I did a manual calculation for all the sheets and found that when I am calculating sheet3 it gets stuck.

I am getting the sheet name using the formula =CONCATENATE(LEFT(MID(CELL("Filename",E1),FIND("]",CELL("Filename",E1))+1,255),LEN(MID(CELL("Filename",E1),FIND("]",CELL("Filename",E1))+1,255))-4),"p")

Kindly let me know where am I going wrong.