Another possible issue is that VBA is case sensitive by default so the string comparisons may not match the actual name of the worksheets - either convert to same case (upper/lower) to compare or include 
Option Compare Text
in the General Declarations section of the module.