Last year I found an amazing freelancer on this website who helped me create some google sheets for my business. Basically I have 5 recruitment offices with staff in. In simple terms, each sales person has their own google sheet that they input their sales figures for the week. This then gets pulled into a master office google sheet and in turn, all the office google sheets get pulled into a company google sheet.
This allows us to review the business each week. There are some other clever things the sheets does but in principal this is an overview.
The freelancer I used is no longer available but she did even create some instructions on how to make the google shets work. I've attached these.
My recruitment company works with UK schools so I need the 3rd term worth of sheets to be created and populated.