[Question] Sumifs multiple sheets with flexible sheets reference

Hi everyone,
I have this issue need your advise:

- I have data across multiple sheets & need to sumifs at summary table (you can see in example)
- I have manage to write a sumifs across multiple sheets with this below formula.

=SUMPRODUCT(SUMIFS(INDIRECT("'"&$G$3:$G$7&"'!C:C"),INDIRECT("'"&$G$3:$G$7&"'!A:A"),$A$4,INDIRECT("'"&$G$3:$G$7&"'!B:B"),$B$4))

However, i need to flexible in choosing which sheets will be put into the reference $G$3:$G$7.
The desired result is: when i change the start & end, the sumif will look from start month until end month (Jan, Feb, Mar...)

I stuck at this point & couldn't find a solution for this one. using indirect to replace $G$3:$G$7 always return with Ref error

Could you help me

Thanks,
Thang Tran

Hi Teylyn,
This is the simplified version I make to illustrate my idea. My working version is 12 months, with proximated ~10,000 rows each months. In addition, there's sometimes bug from the monthly data (which is consolidated by another third party) so we needs to separate sheets in case we need to find where is the error in each months.
With that, do you have any idea to make it works?
Thanks
Thang Tran