I would add (duplicate) the Employee name for every
applicable Row but use conditional formatting to hide it (Font color =
Background).

The Auto Filter will still find all rows  but only the first Employee
name in Column A would show.

Set Conditional Format by selecting all of Column B (assuming first row
is 1) and entering =B2=B1

Copy this code into your sheet code
this after you filter  your employee
double click on the cell to open the hidden rows  below.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
LastRow = 100
CurrentRow = ActiveCell.Row + 1 'get the current row your employee is
showing
While Cells(CurrentRow, 1) = Empty And CurrentRow < LastRow + 1
Cells(CurrentRow, 1).EntireRow.Hidden = False 'unhide all the row
between the employee you want to see and the next one
CurrentRow = CurrentRow + 1
Wend
End Sub

This works well but can this be done just by auto filtering the employee column?

I haven't found a way to trigger the macro with just filtering. I was hoping
someone else could chime in and help us out.

The only way I can see it working is use a pull down instead of filter. When a
new name is selected in the pull down a macro is ran that includes code to
filter (or code to find) by the name selected and then the code I gave you.