Retrieving data from multiple sheets

Hello all,

I have a rather complicated question. I have a workbook with 30 sheets, each sheet represents a day in the month.

I am trying to create a report sheet that will grab data based on Day or Week. I would like to create a report that includes a dropdown menu for a specific date (IE: July 1) and pull the data from that corresponding sheet (sheetname: 0701). I would also like another report sheet that will generate weekly reports. So if I select a week (IE: Week 27), it'll populate data from 7 sheets within that date range.

I've attached an example, if you have any ides on how to go about this, it would be much appreciated! Thanks!

Another perfect example of why databases should be on a single sheet and data extracted FROM the single sheets.

Anyway, like so...

In K27, then copied down/across that table:

=IFERROR( SUMIFS(INDIRECT("'"&L$6&"'!E1:E120"), INDIRECT("'"&$A$5&"'!D1:D120"), $J27, INDIRECT("'"&L$6&"'!B1:B120"), $J$24), 0)


If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

You have violated Rule 4 of our Forum RULES. Don't Private Message, Visitor message or email Excel questions to moderators or other members. (Or Access, Word, etc.)

All questions and answers will benefit other posters like yourself when discussed in public threads. The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.

Breaking this rule is considered harassment by most of our contributors and thus cannot be tolerated. Repeat offense could lead to permanent ban, so do take this caution to heart.

Post your question in a public thread and our many contributors will come to you to assist, especially if the title is accurate (see Rule #1) and you include a sample desensitized workbook that makes it easy for others to try and help.
--------------

I'm sure this was accidental. When you joined the forum recently you agreed to abide by the Forum Rules, but in haste I fear you might not have actually read them. Please stop and take a moment to read them now. We all follow these rules for the benefit of all, as must you. Thanks.

(link above in the menu bar)