Internship Help!

Hello,

I am a young college student that is interning for a business this summer. I am excel certified but I am in no way a "master" of excel. Right now they want me to make two worksheets, one is a budget sheet and the other is the overall month budget sheet. On one sheet, they want to be able to right all the expenditures of an event down. On the second sheet, they want to have all the statistics of all the expenditures that happened in the entire month.

The thing that makes this complicated is that they want it so that whenever you type in a month on the budget sheet, that information will automatically go to the overall month budget sheet. Thus in a way they want it to be "connected".

Is there any way to do this? I thought that a possible way to do this is that they can organize a list of what budget sheets (Lets say, budget sheet A01-A05) they want, and then import it. But this doesn't seem possible anyways.

Thank you for any and all help. Please let me know if there is any more information

Here is the link: https://app.box.com/s/fvphmkpgl69fadt5i0laqm51hck7tlly
in
So let me explain things again so that they are clear.
"Initiative Task Sheet" is meant to be just a short cut to the individual worksheets. Just for convenience so that you don't have to be scrolling so far.

"Budget Sheet" is the template that the business will be using when describing what events/socials/marketing they do and how much they spend on it. What is important is A22-D29. This is what needs to go into the overall Budget sheet.

"March Sheet" is an example sheet of what the overall budget sheets will look like. There will be one for every month. Let me explain to you again what they want. they want it so that whenever there is a new Budget Sheet, for example "C40", the overall budget sheet(s) will look at that worksheet and think "Okay this event was done in march". So the information for that sheet will go into the "march" overall budget sheet.

Again, my problem is not figuring out how to make the overall budget sheet look things up for ONE specific budget sheet.

If you fill out a record with data such:

DEPT, DATE, BUDGET
MARKETING, "MAR 1,2015", $1000.00,

then the 2nd sheet Can be a pivot table of march.
or a pivot table of the entire year.