Update daily company scorecard with summary metrics for project leadership

Your company scorecard depends on manual worksheet lookups, leaving project leads without a nightly consolidated snapshot. It consolidates key totals into one scorecard row so project managers have an accurate snapshot each evening.