Formula with SUMPRODUCT,SUMIFS and INDIRECT is not returning the expected results.

Sorry, I think I accidentally deleted my original explanation:

Hi Excel Experts,
This formulas isn't working for me, and I've tried several variations.

To reproduce the issue please paste the formula into sheet SA cell I7.
Expected results: for Costco/Cherry Soda Week 1/2/16 (“2016*01”) = 100 cases.
Actual results: It is returning no value when I paste it into sheet SA cell I7.

Notes:
I'm using this combination for arguments because I need excel to search multiple sheets and return the total number of cases per week for each customer/product. For Costco/Cherry Soda, etc.
SA is the sheet the results-total number of cases should be posted.
Sheets SD and SD2 are the sheets it should search.
I have two sheets that look identical because my IT person says I'll too many records to combine them into one. This is just a small sample.
“2016*01” on sheets SD and SD2 = 1/2/16 on sheet SA

I setup a table named SheetsTable to use with this formula. Both sheet names SD and SD2 are included in this table.
Can you tell me what I'm doing wrong or suggest a simpler alternative?
Thanks in advance!

My formula:
=IFERROR(SUMPRODUCT(SUMIFS(INDIRECT(“‘”&SheetsTable[Sheets]&”‘!F:F”),
INDIRECT(“‘”&SheetsTable[Sheets]&”‘!A:A”),$A7,
INDIRECT(“‘”&SheetsTable[Sheets]&”‘!D:D”),$D7,
INDIRECT(“‘”&SheetsTable[Sheets]&”‘!G:G”),"2016*01")),)

Thanks Dave, this is really close.
When I pasted it into cell I17, it returned 175. The total cases for Cherry Soda for two different weeks:
Week one = [2016*01 on sheet SD =1/2/16 on sheet SA]
Week two = [2016*02 on sheet SD =1/9/16 on sheet SA]
I'd like excel to return 100 since this is the total number of cases for
CA\COSTCO\CHERRY SODA\2016*01.
Is it possible to tweak the formula to return this result?
Thank you for your time.

That works perfectly. Thank you soooo much!

Hi John, so sorry I haven't responded again to the other thread. I've been working on another project. I have another question about this formula. It worked perfectly in my test file, and I assumed if I changed the tab and cell references to match my real file it would work just fine too.
It doesn't return an error, I just get zeros. I changed every tab and cell reference except this: YEAR(I$6)&"*"&I$5)
What does I$6 and I$5 refer to? Perhaps that's the problem.
Thanks,
Sylvia

Thank you! I just had a typo. I updated those values and it works now.