The answer provided by Mayuhk works for the issue I laid out. But it slows down the function of the workbook to the point where it's basically unusable. I found that using the basic index-match-match functions with an indirect table array nested in each portion works much better.

INDEX(INDIRECT("'" & $B4 & "'!A11:Z41"),MATCH($C4, INDIRECT("'" & $B4 & "'!$A$11:$A$41"),0),MATCH(D$3, TEXT(INDIRECT("'" & $B4 & "'!$A$11:$Z$11"),"mmmm, yyy"),0))