Excel VBA: Copy data from one worksheet to another based on selected criteria in a combobox

Hi Experts,

The set up:
I have a worksheet which I'll refer to as "Snapshot" that has a combobox in cell "A2" using data validation with a list of Supervisors.  

Also in the "Snapshot" worksheet the 1st Row is the header "B1:Z1" who's naming convention matches my 2nd worksheet's (known as "Agent") header exactly accept the "Agent" worksheet's header row starts at "A1:Y1" (1st 3 columns contain = "A" Manager's Names, "B" Supervisor's Names, and "C" Agent's names respectively).

What I would like to do:  
Based on the selected criteria in the combobox of "Snapshot" I would like to be able to COPY data from "Agent" range "A2:Y500" and have the rows of data pasted into columns "B:Z" on "Snapshot".  

For example:  If on "Snapshot" supervisor "TestSup_A" is selected then I would like to find "TestSup_A" name in column "B" of the "Agent" worksheet and bring back all of his or her agent data to the "Snapshot" worksheet.  Bringing back "TestSup_A" Manager and Agent alignment as well something similar to an "index-match" formula.

Sample Workbook attached .

Thank you!  :)
TestProject.xlsx