First of a Few Roadblocks...

GrantSpitler Difficult to visualise what exactly you have designed, but in general, it is not a good idea to gather data in twelve separate sheets and then try to combine these into one master sheet for analysis. Better to collect raw data in one large table for all months and all sales people. No empty rows or columns. No separate sections for new and recurring contracts. Just a sequential list of sales orders with some extra columns that identify the type (recurring/new) and the data. And preferably in a structured Excel table.

Then use Excel's built-in tools to filter, summarise the data by person, customer, contract type, time period. Whatever! These tools could be pivot tables (regular or Power), Power Query, or some of the fairly new and very powerful functions that are available in Excel for MS365 and E2021.