Hyperlink Error if space in Sheet Name

[rod147]

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.