There are several ways that you can use for this. For this type of situation, I usually use VBA to create a macro that loops through the list of employee names, and for each one:
- filters the data,
- updates a template sheet that has the structure for your report,
- saves that page as PDF
Then, you can send each employee their PDF report. It is also possible to automate this, so that you don't have to create and send each email manually.
If you need to have a separate sheet on your file for each employee, that can also be done with macros. Usually, that report template sheet is enough. If at a certain moment you want to look at an employee's report, you can use the report template sheet, pick the employee name from a dropdown menu (or type it in), and choose the month, and the report will populate with the data for that employee and month.
So, yes. This is a project that takes some time to do, but it is possible to achieve what you want with Excel.