I work in manufacturing and am looking to streamline daily reporting from different groups within my business. The example I'll use is the daily production summary that a supervisor or manager sends as an email every night. This email will contain the date, shift, item produced, # of batches made, number of cases made, downtime explanations, and a scan or picture of the written production paperwork. I'd like to be able to use a form that only certain individuals have access to, and have the submitted form populate in an excel file where I can follow trends, calculate loss, etc.
How do I do this? I know that's a pretty broad question, but any help that can point me in the right direction would give me a good idea of what needs to be done.