Judging by this fact, the recommended course of action is to hire the services of a specialized company, a firm that will take care of all the details and subtleties of the spreadsheet programming in your place, and provide you with a ready-made or tailor-made spreadsheet solution that outperforms your expectations.
When your spreadsheet start to hit its limits, what options are open to you? Perhaps the best option is to consider the conversion of your spreadsheet to a database solution. Relational databases became viable not too long after the spreadsheet was well-entrenched as the affordable and quick means of gathering data and performing calculations.
When VisiCalc hit the scene back in the eighties (in the last century), the relatively small group of Apple II users went crazy. It was like manna from heaven for the poor accountants, scientists and engineers who were used to filling in enormous analysis sheets with a pencil. Now, they could use VisiCalc to do the same task, AND calculate the result automatically.
A popular category of ready-made spreadsheets mentioned earlier, is 'Spreadsheets for Actors'. 'Spreadsheets for Actors' includes sets of programmed spreadsheets that are especially designed for professionals in the entertainment industry, from Actors to Producers. The spreadsheets under 'Spreadsheets for Actors' range from facilitating the managing of budgets to keeping track of income emerging from many sources.