Indirect() function not working

Indirect() function not working

H,
I had the following function in Excel
INDIRECT("'" & $A4 & "'!" & C$2)
when imported to zoho, I get an error, event though, apparently
      - indirect() exists
      - what is Inside the parenthesis works and gives " Act 1_1!C26" (tab & reference I want to get the content of..)
 
Can you help me?
 
Thanks
 
Loïc