Hide rows based on multiple ranges not containing certain value of referenced cell

Good morning all,
I'm too new to VBA to figure out how to tackle this scenario. What I'm trying to do is create a tool that will let me select an all individuals or one just one person via a drop down and then automatically hide any rows in three specified ranges that do not contain their initials.

In the attached excel file I've set it up so that I have the drop down in the top left of sheet 1 which is adjacent to a cell that looks up the personnel's initials. I have three named ranges, D3:AL10, D12:AL16, D18,AL22, that I would like to evaluate for that person's initials. If a row in that range does not contain their initials then I would like them hidden. If "Show All" is selected resulting in "All" displaying in B2, I would like all rows to be shown.

Any help would be appreciated.
Thanks!