Thoughts on a tiered audit report - you may have done something similar before

Hi All

I need to create an audit sheet which roughly equates to a one sheet report summarising the input from 6 or so departments. You'd think easy. A single sheet paper copy, passed through hands, is never going to work. Lost - spilt coffee - never saw it etc.

I would rather have the control of the sheet but am unsure the best direction. What I would like is a bespoke "template" like a userform that can be emailed to the respective parties for returned when filled. The templates can then be "pasted" to the final sheet. This means each is responsible for the return of their data, if they dont..tough.. another days work, but the one sheet is not holding up others in the process of being distributed and each entry is private

Can anyone suggest a methodology for this type of thing.. any ideas appreciated

Nigel

Not sure Ali
probably general office as could be a mixture of word/excel/outlook.

Thanks

Hi Richard
we are all operating on 365, is co authoring well documented??

thanks Richard, Ill have a look through later and profile updated