I want to create a sheet that will automatically add any task that has been assigned to me in other sheets. Is it possible to set this up so it will happen automatically? I would like to avoid having to manually add every new task I am assigned from every project I am working on. Ideally I would like to set this up for my entire team (5-10 People) so each has a dashboard of sorts. If I had to do this manually it would be tedious and time consuming enough I would have to give up.
