Need help with concatenation syntax

[Pawtang]

I've got this egregious bit of code here. It won't do any good to explain exactly what its trying to do; the main part I am trying to correct the syntax for s in the first "Indirect" function. I am trying to pull references from two cells into the formula, from cell C3 and cell H3. I am getting a #REF ! error

=COUNTIF(INDIRECT("'"&$C3&"'!C$'"&$H3&"':W$'"&$H3&"'"),"Y")/(COUNTIF(INDIRECT("'"&$C3&"'!C$10:W$10"),"Y")+COUNTIF(INDIRECT("'"&$C3&"'!C$10:W$10"),"N"))

It worked when I just had this:

=COUNTIF(INDIRECT("'"&$C4&"'!C$10:W$10"),"Y")/(COUNTIF(INDIRECT("'"&$C4&"'!C$10:W$10"),"Y")+COUNTIF(INDIRECT("'"&$C4&"'!C$10:W$10"),"N"))

But i have to add the second reference to index to the correct row on the linked page.
Mainly I don't understand the whole nested quotation marks logic. Can anyone explain whats wrong and how to fix?

 

[Pawtang]

Ok, I've solved my own problem. It was the second appearance of single quotes - ' - that I had used. Took those out and it works just fine.