Sumproduct SumIF Indirect functions across multiple tabs

[KRE]

I have 12 tabs for each month of the year. I'm trying to return a name that is listed in a cell tied to a date range on my summary page. See below. I know that the reason this formula isn't working is because a name isn't a value but i'm not sure what formula would work?

Each tab is similar as below.

My formula should return Esteban Mendoz in column K of my summary because it matches to the week number.

 

[Fluff]

The spill error means that there is more than one match. What should happen for that?

 

[KRE]

I figured it out. I put @ in front of Let so the formula wouldn't spill into multiple cells

 

[Fluff]

Glad it's sorted & thanks for the feedback.