What (VBA or Excel) to use for ths problem and how ?

[fabsic01]

Hey Guys,

This is my first time on this forum and also the first time im stuck in excel so hopefully one of you can help me out and save me a lot of work.
I am currently working on a 'rent roll' sheet that tells me how much rent i can expect from multiple (20) tenant's each month. As of this moment this sheet extends up to 20 years (240 months).
What i want to add is an executive summary on a different tab which sums up the total rent roll per year. Now the formula to do so isn't the problem but i need to make a lot of seperate formulas for each year and i was wondering wherther there's an easier way with excel or VBA maybe?

I 've added an short (3 tenants and 25 months) example to this thread to show you what i mean.

Thanks in advance for your help

best regards,

steffen