Help with formula that filters through multiple sheets

Hey all!

I need a formula that filters through multiple sheets to tell me how much a person spent on an item (soda, etc) monthly. The reason there are multiple sheets is because they are different bank accounts that the same people use (ALL WORKSHEETS ARE SETUP THE SAME WAY). I know I have to use INDIRECT, SUMPRODUCT, and possibly SUMIF.
I looked at some example of people using INDIRECT, but I am confused about the formula as a whole specifically date ranges. Please break down what each section means within the formula.

So when I type in "Bill" in C2. it should populate from January through December what Bill bought that month. Like He bought $50.00 of soda in February and in December he bought $10.00.

THANKYOU!

Christopher: I like the setup that you did, but I want the worksheets to be by account not by month. So it's the total of Bill's spending on a certain item throughout the accounts.

Ford: is C749 where I put the criteria? and if so how do i input the date ranges to say "<=" or ">=" a certain date.

This is how I want it to work. On the first sheet (Summary) when I enter in person's name on F1, The formulas in the chart should gather all of the information in sheets called "Account 1" and
"Account 2" relating to Bill. Bill used both accounts and so the the information should be by month and total of each category.

Your equation works, I just need to figure out how to do the date range criteria for C794 in your equation

what does the formula do? is it renaming the ranges?

@FDippins or anyone else I have come up with this formula, but I only get 0 as the answer

=SUMPRODUCT((SUMIF(INDIRECT("'"&Accounts&"'!I3:I1000"),$F$1,INDIRECT("'"&Accounts&"'!BC3:BC1000")))*(SUMIF(INDIRECT("'"&Accounts&"'!C3:C1000"),"<=1/1/2015",INDIRECT("'"&Accounts&"'!BC3:BC1000")))*(SUMIF(INDIRECT("'"&Accounts&"'!C3:C1000"),"<=1/31/2015",INDIRECT("'"&Accounts&"'!BC3:BC1000"))))

Column I = The persons name (which will be entered in F1)
Column BC = The Money range
Column C = The dates


Am I close???

I have figured it out!!! Posting my formula so other people can hopefully find it useful

I just need to use the SUMIFS Formula with the INDIRECT and that helps with my multiple criteria when having date ranges. NO SUMPRODUCT!
D Column= Money totals
I column = Name which is entered into F1
C Column = Date
S Column = the actual date (1/1/2015, 1/31/2015) need "&" before the date

=SUMIFS(INDIRECT("'"&Accounts&"'!D3:D1000"),INDIRECT("'"&Accounts&"'!I3:I1000"),$F$1,INDIRECT("'"&Accounts&"'!C3:C1000"),">="&S2,INDIRECT("'"&Accounts&"'!D3:D1000"),"<="&S3)