Unable to use SUMIFS with INDIRECT together

Hello

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

Formula:

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:

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.

YES!!

This works!!

Thank you!!

Just for information. What was my mistake? I am not able to find it!