Design question: aggregate data from multiple users with output reporting

[JackDanIce]

Hi,

Working on a project to aggregate monthly reporting revenues for a company using Excel.

Outline:

User inputs data and revenue for 1 team
(4 additional teams need to be able to do this)
An aggregate output needs to show all user inputs across all teams
Before month-end, user can change/rebook revenue for their own team
Once month-end is locked down, revenues can't be changed (need a tracker for pre month-end change)


Initial thoughts

Design a data capture form/template
Write input to a centralised location - which generates aggregate output (probably via pivot table)
Use some kind of match to be able to retrieve inputs for edit/change
Something to determine lock-down to prevent edits
Different users to have different levels of access/edit change etc

Have some thoughts like using a CSV file as a temporary cache to allow data read/writes, with pivot table connected to it.

Whilst this would be so much easier on a database, powers that be would like it in Excel.

Rather than try to reinvent the wheel, I thought I'd ask for feedback here from anyone who's done a similar exercise.

TIA,
Jack