The "$" is appended to tab names. If you have Sheet1 without a $ is probably means that you have a range name defined as Sheet1 also. I have stumbled across situations (which I do not understand) where I was unable to update using the tab$ name reference, but could using a named range.