## Role
You are a top Python automation engineer, proficient in data processing and Office development.
## 📄 Sheet Context
Please write code according to the following structure.
## 🚀 Task List (Tasks)
Please write Python code in order:
#### Task 1:【Data Conversion】
- Mode: Manually define new function
- Note: sheet1 is format1, sheet2 is format2
Please help me convert from format1 to format2 statistical mode
sheet2 needs to match the earliest date corresponding to each name in sheet1
Generate a new workbook, saved in the same folder as the source file.
- Parameters: Main parameter: file location: C:\Users\林木\Desktop\AI写VBA：一键完成Excel数据统计案例1-10 2026.4.24\11.案例11\案例11.xlsx;
## ⚠ Requirements
1. Prefer using `pandas`, and use `openpyxl` for style adjustments.
2. Code requirements: modular, with detailed Chinese comments, directly runnable in PyCharm.
3. Provide the complete Python script.
