Help! Creating summary sheets for a master multi-field budget

Hi, Not sure if this is the right part of the forum to ask this, but hopefully someone can help me out!

Basically at my work we run a lot of listings adverts for events we put on. The cost of each advert and it's design is split between the different events included, based on how large they are.

We then have to create a summary for each Event which lists just their split of the adverts. So far I have just transferred this data from the main master budget to a separate sheet.

I'm wondering if there's a way for this to be done automatically? I've attached a sample file with a small mock-up of what would be the master budget and one of the summary sheets. (The real budget would have 40-50 different events, each event being included in 30 or so different ads etc).

Is there a way to do this or something similar?

Thanks in advance!Marketing budget example.xlsx

Try the following sheet..

I think Pivot tables will help you, if you want to enlarge the scale of detail....

or

Vba...


Don't forget to click *

Thanks so much, this is a great start.

I'm just wondering now, how can I include the date in the formula too? As in my full size budget there are many adverts in the same publication but different issues, so different dates, is that possible?

Sorry I'm totally new to all these excel formulas...