Hyperlink To 53rd Payroll Week

Sso if you've done payroll before, you may have run into the 53rd instance of a payroll week. Today I've been editing my payroll template to compensate for this occurrence and I've almost got it complete but of all things to mess up on me, a hyperlink is the problem.

I have a legend where I can see all of the payroll week periods, the amount paid, PTO used, etc. And ALL of my payroll sheets are named "Payroll #1", "Payroll #2" ... "Payroll #52" and have a cell on my legend that hyperlinks to cell $A$1 of the corresponding sheet. But when I went to add in this 53rd week, the hyperlink has decided not to work. It will work if I name it anything else, and it will work if I take the # out of the name it will work, but I want to have the # in the sheet name because all other 52 sheets are named thusly and I would rather fix this one link than go back and replace 52 other working links and risk breaking something else.

Here is an example of one of my working links:
Screen Shot 2013-07-30 at 5.41.42 PM.png

I created the Payroll #53 the same way:
Screen Shot 2013-07-30 at 5.42.50 PM.png

But it always resets to this as soon as I try using the link:
Screen Shot 2013-07-30 at 5.42.15 PM.png

And pops up this error:
Screen Shot 2013-07-30 at 5.47.35 PM.png

I do have a VBA Macro that hides both that sheet, and the row referencing Payroll #53 on the legend by using a checkbox. I'm not sure why the # sign is making everything so difficult when there are 52 other hyperlinks that use it also. I tried deleting my macro to see if that was part of the problem but it still refuses to properly create the hyperlink. I also tried rebooting to see if that was part of the problem but it wasn't.

As a side note, this particular cell will not link to any page with a # in the name.
Screen Shot 2013-07-30 at 5.45.51 PM.png

I tried creating the hyperlink on a Windows based machine (since Microsoft is native to the OS after all) and it worked. So it must be a bug or something in the Mac version.