There are a lot of data which I require from my team of 24 pax on a weekly basis. There are standard columns from A to T.

What happens now is that when 1 person goes in to update the data, he
- runs the risk of corrupting the master data
- locks the workbook and can't let other people input their data (we can't use office 2016/365 here) on the shared drive

I'm thinking to let each member have their own workbook with the same template, and run a macro (or using some other trick) to auto-combine their entries within a table across 24 workbooks.

Is that possible? Ideally, there should be no hardcoding but if not, happy to consider other options too.


**********************************************-

Separately, I have created a few Pivotcharts but it's weird that the default is I can only display in Quarters or Years, but not Months. Even with an additional Timeline bar, the charts will only display in Q or Y, but not M. What is wrong and what can I do to rectify the issue?

Thanks!