How to integrate/sync several sheets into one?
I have a team that is working on several projects. Each team member has a sheet that lists their tasks. How can I link/sync each member's in-progress tasks to show up in a separate sheet? I'd also like to be able to modify and add tasks in the master sheet so that the changes and additions can appear in the assignee's sheet.