I am creating a sheet that will pull information from another sheet based upon a drop-down list.

There are two sheets. "Group" and "Individual"
"Group" contains three columns, "Account", "Rep", "Type".

When I am on the "Individual" sheet, I have a cell with a DV list of all the possible "Rep" options. When I select a "Rep" I would like that sheet to populate the other information.

Example:
When "Dan" is selected I want all of Dan's accounts and account types to be listed.

I cannot figure this out. Please help. Thanks!