I'm trying to create a hyperlink in a cell on Sheet1 to cell A1 in Sheet2.
The value of Sheet1!A3 is Sheet2.
I'm entering this formula, and no error value is returned, but it just
doesn't go there.
Here is the formula:

=HYPERLINK(INDIRECT(MID(CELL("filename"),FIND("[",CELL("filename")),FIND("]",CELL("filename"))-FIND("[",CELL("filename"))+1)&A3&"!$a$1"),A3)

Any ideas?