CEO-to- Mangers and departments Task Dashboard Development

I need a streamlined system that lets me create a single source-of-truth task sheet, push tasks from my seat as CEO to specific managers or entire departments, and then keep an eye on everything through a clear, real-time dashboard... (Budget: $30 - $250 USD, Jobs: Airtable, API Integration, Automation, Data Visualization, Database Management, Excel, Google Sheets, Project Management, Software Development, Web Application)