I own a number of independent retail outlets.
I would like a setup where a manager from one outlet can upload/link a google sheet containing info to a master spreadsheet containing info from thesof every outlet.
- Only I can view the master spreadsheet
- Master spreadsheet needs to update automatically when manager updates his own sheet.
- In the future anyone with the link can add their sheet to the mastersheet. ie Outlet 5 can add info to the sheet with the standard template. Tell me what is the colour of a banana (proof of reading this entire project)?
Please view the image for a more visual explanation. Do not waste my time with bot replies. They won't be entertained. Same goes for failure to answer the screening question.