Secure Sales Tracker Excel Workbook

I need an Excel workbook designed to track sales for manufacturing. Each sales rep will have their own sheet that can be seen by them only. They will enter their password on opening the workbook and be taken to their sheet. There will be a hidden sheet with users logons recorded for supervisor usage.

Essential Features:
- Fully hidden sheets, accessible only via password
- Summary page displaying sales totals per product
- Data validation rules using IF statements (e.g., if the 'date shipped' cell is empty, then add order to totals)
- Easy to add additional sheets as needed and to add additional columns to sheets as products are increased.

Ideal Skills and Experience:
Must know VBA as workbook and worksheet veryhidden must be employed
- Proficiency in Excel, especially with data validation and IF statements
- Experience in creating secure, password-protected workbooks
- Attention to detail and ability to follow specific requirements