How to change the reference worksheet based on a value of a cell

I'm using countif formula to count a value in a range:

this the formula i used and this worked.
=COUNTIF('Nery Roxas'!G5:G25,1)

But I want the worksheet reference to be based on a cell.

in cell A1 the value is Nery Roxas, the formula should be like

=COUNTIF('A1'!G5:G25,1)

but it gives me error.

Thanks in Advanced!

=countif(indirect(a1& "!g5:g25"),1)

Maybe:

Please Login or Register  to view this content.

it give me an error. anyway thanks!

What is the error? Do you have a Sheet Name in Range("A1")?