Display sheetname in cell formula


=MID(CELL(“filename”,A1),FIND(“]”,CELL(“filename”,A1))+1,256)