Hyperlink Error if space in Sheet Name

Hi,

I am using this formula to insert a Hyperlink table of contents in my workbook.

It works very well even if you rename, reorder the sheets, except if there are spaces in the sheet name when I get "Reference is not valid" error message.

Suspect it needs one or two apostrophe's adding?

=HYPERLINK("[TEMP C1485-10-20.xls]"&IFERROR(INDEX(MID(Sheets,FIND("]",Sheets)+1,255),ROW(A1),1),"")&"!A1",IFERROR(INDEX(MID(Sheets,FIND("]",Sheets)+1,255),ROW(A1),1),""))

Workbook attached:


Thanks.

Try

=HYPERLINK("'[TEMP C1485-10-20.xls]"&IFERROR(INDEX(MID(Sheets,FIND("]",Sheets)+1,255),ROW(A3),1),"")&"'!A1",IFERROR(INDEX(MID(Sheets,FIND("]",Sheets)+1,255),ROW(A3),1),""))