Spreadsheet that collects data from multiple sources.

Hi All,

I have recently become a line manager for 6 people. I am keen to manage their workloads whilst reducing administrative duties.

Current workload:
Each of my employees have a worksheet which they keep track of their clients and payment statuses. Once payments have been completed, they enter details on a Team spreadsheet which becomes difficult when people are using it (Locks to other users).

Solution (Hopefully this is acheivable):
A template spreadsheet which my employees can complete on a day to day basis. Data can then be collected into a 'master spreadsheet' which will save them double-keying.

Thank you in advance!