Sales Activity Dashboard Automation

I need a comprehensive sales activity dashboard that aggregates live data from 45 salespeople. The dashboard should be built using Google Sheets, Google Sheet Pivot, Google Looker Studio, and Google Apps Script.

Key Requirements:
- Fetch live data from 45 individual Google Sheets
- Track and display the following data points for each sales person:
- Number of calls made
- Sales conversion rate
- Client feedback
- Visualize data in tables on a common dashboard
- Provide daily automated updates

Ideal Skills and Experience:
- Proficiency in Google Sheets, Google Apps Script, Google Looker Studio
- Experience with data aggregation and visualization
- Strong understanding of sales metrics and dashboard design
- Ability to set up automated alerts

Please ensure the dashboard is user-friendly and allows for real-time updates.