SumProduct formula only working on 1 of 3 sheets

I have a excel doc that is driving me crazy and I need some help. The attached doc has 4 sheets on it. The first three hold data and the fourth is a viewer for it. I created a formula that searches for a name in the data tabs and carries the data over to the stats viewer. there is a drop menu at the top of the stats sheet that lets you choose which sheet's data you are viewing. The problem is that the formula works fine when you choose the third sheet, but when I choose another sheet I get errors. I'll attach the doc here. Any help would be great!