Currently at work I am trying to create a task sheet system. Basically for each job there will be a Master sheet with a variety of tasks for several different people, from this I'm looking to create a task sheet specific to each person. I would like to be able to add a task on the Master sheet and it appear on the respective person's page. As well as this, if the person makes a note on their personal sheet then it would appear on the Master.
However the complicated part is that there is constantly multiple job's with their own Master sheet and I want each of these to contribute to the persons overall task list.
Could anyone please suggest how I go about this? I have attempted using Google Sheets but I can't get the two way sync to work. So I was thinking of using a combination of Microsoft Access to store the data and Excel to present it.
Any help would be great!