The task at-hand is I coordinate the activity of 20 organisations, each of whom I need to collect monthly data from directly, about the tonnages and types of elecronic items they collected for reuse and recycling. They all use different systems and processes so it's not a case of plugging into an existing system.
Rather than have 20 separate templates they fill out each month that I then have to check, collate and organise every month, I'm hoping there's a better (automatable) solution.
What I'm aiming for is that each organisation has access to an online data entry portal (say a google sheet), and they just drop in the monthly numbers once per month. I can then review these altogether monthly or less frequently.
Ideally they each have access to a single tab within a sheet with 20 tabs so I can keep it all in one place. Alternatively, we may have to have separate sheets for each. Would consider other options too.
Please let me know if you think there's a fairly simple way to do this, also simple enough for some users with low-average computer skills. If you think it would be better to use other systems than sheets, I would also be interested to know thoughts.