Spreadsheets are a good place to keep small amounts of data, but as soon as you want to connect spreadsheets to each and generate reports it becomes a challenge.
I’ll get people asking me how much it costs to make a custom app for situations like this and it can range from hundreds to millions of dollars.
What I recommend trying first are two programs that can take your spreadsheets and give them superpowers.