Try this in a sample workbook

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

you do not have to put the Text "Exhibit" this will get the sheet name.