SUM multiple variables across multiple sheets

[itsnick]

Hello ,

First off thanks again to all the members that have helped me on this forum. I have a issue and I've attached a dummy workbook to hopefully better explain my problem.

Basically I need for a process to find and sum values based on a few variables. Row 5 needs to pull data off the two sheets (GRO&PRO) Based on the following variables, Week, Type, and Name.

For example, B5 would search the sheets GRO & PRO for the week listed in C2 which, Then check for the Name which is listed in B4, and finally check for the type which is listed in A5. The results should all be summed and returned in B5

I just need the basic idea of a macro or formula that would work and I can get it around to the whole sheet.


Thanks again