Greetings!
i have created a workbook with several sheets on it and the data takes readings from the sheetname. below are options and all of them, do the job for me what i need.
Option 1:
=MID(CELL("filename",I9),FIND("]",CELL("filename",I9))+1,255)
Option 2...