Dynamic Cascading Dropdown with Nested Dependent Lists

Create a sophisticated Excel workbook with multi-level dependent dropdown lists that dynamically update based on previous selections. The first dropdown should populate categories, the second should show specific sub-items, and the third should display granular details. Include data validation, error handling, and a mechanism to reset cascading lists if a higher-level selection changes. Demonstrate how this could be used in project management, inventory tracking, or resource allocation scenarios.