Add Condition For if and sumif Function Formula

I am hoping to some help with a formula. I use the attached spreadsheet to track professional development within our organization. I know it would be much easier to create a Access database for all this spreadsheet is doing but for reasons I don’t quite understand we do not have Access available to us. So I created this spreadsheet last year so we are able to track and analyze our professional development for staff in 1 centralized location. The spreadsheet is also used to summarize the budget. I have a tab called Budget Summary that refers to the tab that the data is collected. Rather than create a new spreadsheet for 2015 I think it would be much to add a Budget summary tab for each year and continue to collect the data in the same spreadsheet so I am able to look at data through pivot tables over the years. My problem is that I did not not think of this last year when I created the spreadsheet. The formulas I created do not allow for a separation of year. I have added a column on the Data tab for “Year of Event” and I have to create formulas that will let me add another condition that will separate the year. On the Budget Summary tab I have a “Reimbursed Summary” and a “Budget Code Summary” and I am struggling to come up with an adjustment to the current formulas or a new formula that will do this. Formulas in both summaries are doing quite a bit already so I am no sure if it is even possible to keep everything they are doing now and still be able to separate the year. My plan would be to have a Budget Summary tab for each year. If anyone is able to help it would make this spreadsheet so much more functional for me. I have deleted a lot rows from the Data tab. We have a very large number of events for our organization that this spreadsheet tracks. I have also removed employee names and info. I think you can tell by reading the formulas what exactly they are doing but I can clarify if needed.

Thanks s much in advance to anyone even willing to try

Just amazing. Wow. I don't know how to thank you. You made so many amazing improvements to the spreadsheet. I have applied it all to the current spreadsheet with all of the data and everything works perfectly. I like the way you have set up the budget summary page much more then the way I had set it up. I did not like all of the rows showing under the Reimbursed Summary but did not know another way of doing it. Same with the Budget Code Summary. I love that finance can now just populate the budget code. You are amazing and I can not thank you enough. Now I just want to analyze the formulas if I can and see if I can figure out how you did it.