Adding one cell through multiple sheets with criteria

I have a workbook for collecting Fruits and Berries. There should be worksheet for every day of the year, monthly summary for every month (separately for Fruits and Berries) and annual summaries for Fruits and Berries. For every day I don't know if it's gonna be Berries day or Fruits day. Worksheets for Berries and Fruits are slightly different, and that is important.

Berries table for August 8 https://imgur.com/FpvkR1C

Fruits table for August 6 https://imgur.com/HpFX6tP

Monthly and annual tables are the same, just have different values in Goals.

I was trying to write a formula for summing monthly (weekly, annual) quantity, for C6. Basically, I need just to sum one cell across a lot of sheets, but with criteria, and I can't do that. I was trying to write formula for weekly quantity, assuming that Aug 1-7 are Mon-Sun (I don't need weekly, just trying it as an example; I hope if I will be able to make weekly summary work, I will be able to do monthly and annual summaries work too.) I tried to use SUMIF and SUMIFS for a weekly value for Fruits:

SUMIF('Aug 1:Aug 7'!C6,A4,'Aug 1:Aug 7'!C6)

A4 has Type:Fruit as a criteria. And I tried some other combinations, but nothing works: https://imgur.com/bfVbkWI

I want to add all C6 values there for all Fruits days of Aug 1-7 (it's Aug 1-2 and 4-6; for Monthly that would also include Aug 8 in that table).

Can it be done? What I am doing wrong?
----
Another question is about days. As I mentioned, I never know what it is gonna be that day, Fruits or Berries. Is that possible to create drop-down menu that changes type? I don't even know how to approach that. But I need to create a worksheet for every day of the year. And if I'm not going to find how to change this type, I would need to create two worksheets for every day, for Fruits and for Berries.

Can I just create a lot of pages for every day of the month (like 31 pages for August), and switch effortlessly between Fruits and Berries for any day?

Berries table for August 8 https://imgur.com/FpvkR1C
Fruits table for August 6 https://imgur.com/HpFX6tP

I uploaded it to Google Drive https://drive.google.com/file/d/0BwU...ew?usp=sharing I was using worksheet 'Week 1 Fruits' for trying different formulas.

Thank you very much, and sorry if what I described is unclear or/and stupid.

There is a table on the right for sheets: https://imgur.com/bfVbkWI
So I think I found partial solution. I was using formula

Formula:

Please Login or Register  to view this content.

I got it from https://www.youtube.com/watch?v=tmh5vI5dK6o ("Excel Magic Trick 780: 3-D Cell References For SUMIF Function - Adding with Criteria Across Sheets").

You wan't believe me, but even for that I was searching for a long time, like 4 days full time.
What can I say, I am not too bright Anyway, that's a great step for humanity... Or at least for me.
I work a lot with Excel but usually with much simpler stuff. I need to update my skills very-very much.

Still it doesn't solve my problem. I need to have worksheet for every day of every month, and possibility to change Fruits to Berries and vice versa for each day.
Please, help me...