Hi,

I was asked a similar question by a client a couple of years ago and in the end we decided that Google Docs allied with Google sheets was the most robust solution.

The Docs allowed different people to add data whenever they wanted and each entry is logged within a Sheets document - or if you prefer an Excel workbook which can be analysed in the normal way with either Sheets or Excel standard functionality.

You may also find that you don't need to bother with creating a new log sheet when the month changes since you will have all the relevant dates/times in the Sheets document stored in the cloud and it would be easy to analyse by month with a Pivot Table or other functions.

Since then I've used it for a few of these 'how do I capture data in real time' exercises. The big advantage is that it overcomes all the limitations of the Excel 'Shared Workbook' functionality.

Although to be fair I don't know whether the shared functionality aspect of Excel has moved on with Excel 2016.