Excel VBA Payroll Automation

I need a streamlined VBA-driven workflow in Excel that lets me handle all incoming payroll data quickly and error-free, then produce a clean summary at the click of a button.

The workbook must support three core activities:

1. Data entry – A simple userform for typing in one-off adjustments or new employee lines.
2. Data importing – A macro that pulls in weekly CSV exports from our time-clock system, places them in the right tables, and maps every column automatically.
3. Data validation – Rules that flag duplicate employee IDs, detect missing dates or rates, and stop bad records before they pollute the file.

Once the data is in place and passes validation, I want a single “Generate Summary” control that produces an easy-to-read payroll summary (employee level and grand totals) on a separate sheet, ready for printing or PDF export.

Acceptance criteria
• Import routine handles at least 500 rows in under 5 seconds on a standard office PC.
• Validation highlights issues in-cell and lists them on an “Errors” sheet for quick review.
• Summary refreshes instantly and clears any previous output to avoid stacking results.
• The entire solution stays within a single macro-enabled workbook—no external add-ins.

Please write clean, well-commented VBA so I can adjust calculation logic later if needed. Let me know any clarifications you need before you start coding; I’m happy to share a sample data file.