Pull Data from multiple sheets for a responsible team into a single sheet

Hey Community,


Hoping to get a bit of help. I have 36 sheets that are all active. Each of these sheets has tasks assigned to multiple teams. I need to pull tasks for one team from all 36 sheets into a single sheet. I can't do this into a report because the hope is to link to google calendar. Since reports can't link to calendar it will have to be into a sheet. I also want this info to be updated live. So if a task is added it will be updated automatically. I am open to any ideas to make this happen!


Thanks!

Answers