Trying to find a faster solution than array formulas

So I have this database in excel of manager stats like sales, labor, service times, etc. data.gif And each stat is awarded a number of points based on a formula that calculates the value according to a target. So, what I need to do now is make a manager summary where each shift of a particular manager is listed so that manager can look at a detailed report of each shift and see how many points they got for each category. Like So:shift detail.gif

The way I did it before is a little trick I got off of the Microsoft excel website:
{=SMALL(IF(Managers=$C$2,ROW(INDIRECT(B$1))),A6)-ROW(INDIRECT(B$1))+1}
What it does is pull each shift starting when the first shift that matches the manager name. Now you see, the problem is, as you might have figured out, is if each manager works that 5 days a week and I have 6 managers, and 4 weeks in a month, that 120+ array formula's. That's a lot. I've thought about using a pivot table, but I need to include two rows of data from two different tables. And I wouldn't know where to begin using database functions, besides, I don't see how that would pull out individual shifts.

So, if there are any suggestions or ideas, let me know, thanks.

I did it! Here what I did. shift data update.gif Over there on the right I used DMin function (=DMIN(Data, "Index", R6:S7)) that returns the first index value where the manager name is Jamie. Then on the next line I included another criteria that searches for the first index that's greater than the last on. It worked out pretty well. Thanks for you help.