I own a digital marketing agency and I started using Google Sheets as my project management tool. I have multiple clients that I work with.
So I have created a Google Sheet for all my project management and created multiple sheets for each client. But this is a little bit painful for my team as they have to go through each sheet to know what their tasks for today are.
So what I am planning to do is create 1 common sheet where all their tasks will auto populate, so all my team can just go into that one sheet and see what their tasks are. But I as a founder would like to use each sheet for each client as it's easy for me to plan ahead.
So is there anyway I could auto populate all this data into one sheet, meaning everytime I add a task in any of my client's sheet, that particular row/task will need to be automatically added into the common sheet that my team uses, so it's easy for me and for them. I am also attaching a screenshot of how a sheet would look within our business.