I'm trying to use the indirect function to reference tab names to pull in data. The tabs use dates as the names (Feb 5, Feb 12, Feb 19, etc.). I've used several different versions of the formula I've found on excel sites and forums and they all spit out "#REF!" for me. I just want to be able to say, "go to the Feb 5 tab and return the value of cell C40". This doesn't seem too complicated, but I'm obviously missing something here.

Could someone help me out with this? I don't understand the syntax of the formula, with all the " , ' , & , and !. Alternatively, is there another way aside from indirect to look up data by tab names?