Hello

I use this formula, and i get some results from another sheet(sheet name =test) that works great

Formula: copy to clipboard 
SUMIFS(test!$G$4:$G$1000,test!$B$4:$B$1000,">="&$A4,test!$B$4:$B$1000,"<"&$A5)


As i have many sheets that i would like to choose the sheet that i like to get the results, i put the sheet name in B1 and tried to use the INDIRECT function. This gives me a mistake.

Does anyone see any mistake in my formula?
Formula: copy to clipboard 


SUMIFS(INDIRECT(""&B1&"'!$G$4:$G$1000"),INDIRECT(""&B1&"'!$B$4:$B$1000"),">="&$A4,INDIRECT(""&B1&"'!$B$4:$B$1000"),"<"&$A5)


Thanks in advance for any help here.