which formula returns the value in cell a1 of the worksheet named mysheet code example

Example: excel formula sheetname in cell

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)