Real-Time Collaborative Excel Spreadsheet Open

I'm working on creating a master checklist that pulls from each department’s specific checklist—something they can be actively using during a crisis response. The goal is for the master sheet to update automatically as team members work through their tasks, so that management can easily track progress in real time across all departments.