Excel Internal Hyperlinks to Worksheets with Space in their Names
Solution 1:
When using a sheet name with spaces, the sheet name needs to be contained in single quotes:
=HYPERLINK("#"&"'List of cases'!A1","All Cases")
OR if you want to use CONCAT:
=HYPERLINK(CONCAT("#","'List of cases'!","A1"),"All Cases")