The following formula works. Is there a more elegant way of doing this?

=RIGHT(CELL("filename",Sheet2!$A$1),LEN(CELL("filename",Sheet2!$A$1))-FIND("]",CELL("filename",Sheet2!$A$1)))