Automated PPE Inventory Excel Template

I need an automated Excel template to track PPE equipment inventory for 160,000 personnel across various states.

Requirements:
- Track:
- Item type and quantity
- Location and assigned personnel
- Purchase date and expiration
- Include automatic alerts for:
- Low inventory
- Expiration dates
- Data updated manually by staff

Ideal Skills:
- Advanced Excel proficiency
- Experience in inventory management systems
- Automation skills in Excel (e.g., formulas, macros)
- Attention to detail and organizational skills