Client account Spreadsheet - Compile error - to large to need shorten code

Hi guys,

i am no programmer. Our accountant wrote us an excell sheet to handle client money and up to 25 properties and now thats its full they want loads more cash just to make more sheets They know they have us over a barrel and are charging 3x the amount that we paid just for the spreadsheet in the first place. We are a small business and cant afford these costs

I have been able to work out how to add more sheets and spent some time adding from 5 more sheets. This worked fine and my 30 property spreadsheet works. so i continued and added to 50 as we need them and boom

The code works but now it says compile error. procedure to large. I would like someone to help us and do it for us. I don't mind paying even.

I am hoping that you guys can make the code smaller for me for it to work. here is all of it. I am sure u gurus will understand it and can do it in 2 mins.

here is the code https://gist.github.com/anonymous/4730171

thanks for your help. We are a bit desperate as we cant function really without it.