Dynamic Multi-Criteria Cascading Dropdown Validation System

Create a sophisticated Excel workbook with interdependent dropdown lists that dynamically update based on previous selections. Design a system where selecting a parent category (e.g., Department) automatically filters and populates child dropdowns (e.g., Specific Roles, Budget Codes). Implement data validation rules that prevent invalid entries and include error handling with custom messages. The solution should work seamlessly across multiple sheets and support real-time recalculation without manual intervention.