I’ve had a good read up, it seems very easy to do this if using MYSQL databases and PHP to pull the necessary data.
Problem is I can’t give access to normal backend users to the databases. They currently already use an online share spreadsheet to do this, some use Google Docs and others are using Office 365.
If anyone can think of a solution, it will save me a few grey hairs…