Excel Team Roster Automation

I need an Excel-based team roster automation tool. It should handle multiple variables and integrate with other Excel files.

Key Requirements:
- Intermediate automation with custom scripts
- Pull data from other Excel files
- Prioritize:
- Week off
- Proficiency level at each process path
- Rotation in shift

Ideal Skills & Experience:
- Proficiency in Excel automation
- Experience with custom scripting
- Familiarity with Excel data integration and management

Looking for efficient, reliable solutions.