You need INDIRECT:

=COUNTIF(INDIRECT("'"&C1&"'!M:M"),B2)