problems with hyperlinks linking to other worksheets

I have managed to find some code which, upon pressing a command button on the 1st worksheet in my workbook it:

1. populates a list of the names of all the other sheets in the document
2. converts each name into a hyperlink that when clicked, opens the sheet. (or at least it should)
3. Add the word 'menu' in cell A1 of each sheet that is a hyperlink back to the menu sheet

There are around 40 sheets in the document so you can see why this is easier than scrolling along the bottom to find the correct one. Or it should be.!

At the moment. The list populates correctly but when i click any of the hyperlinks in the list that are more than 1 word or have a space it brings an error message "reference is not valid"

(in reference to point 3 above, the menu link on each of the other sheets works fine)

I can fix the error by manually editing each hyperlink but, when I add a new sheet by clicking the button, it then reverts back to the error.

I have attached a copy of the workbook to take a look at and would very much appreciate some help or an idea of where else I can find it. (FYI there is no data on any of the sheets and i have changed the names of the sheets due to data sensitivity issues)

Many thanks

There are only 37 Worksheets in your example, Column A needs to be cleared before you run the rest of the code.