Is there a way to reference sheets by their sheet name,ie, sheet1, sheet2, etc, instead of their tab names? I need to do this in a formula, not in VBA. The formula is as follows: =SUMPRODUCT(($A18=INT(Mo.2!$A$2:$A$100))*(Mo.2!$G$2:$G$100)). I want to be able to change the "Mo.2!" designator to the underlying sheet name, in this case sheet3.