Excel Attendance Tracker with External Data Form

I need a Microsoft Excel based attendance spreadsheet system. This project involves creating an Excel spreadsheet for attendance with a simplified data entry via an external linked form. The system should automatically generate attendance reports in Excel format.

Ideal Skills:
- Proficient in Microsoft Excel
- Experience in creating linked external forms
- Knowledge of Excel's data analysis and reporting capabilities

Requirements:
- Design a user-friendly external form for data entry
- Implement a system for automatic report generation
- Ensure all reports are in Excel format

Please ensure the system is intuitive and easy to use.

The data complexity for the system should be basic. The external data entry form should be implemented using Microsoft Forms.