Dynamic Table That Adds & Removes Rows Based on What's Autopopulated Through An Array Formula

[noogetz]

I'm trying to create a dynamic table that expands and contracts based on what data is autopopulated. I'm currently using a combination of an array formula and vlookup to get the second table on the second sheet to autopopulate based off of the first table on the first sheet, but I can't seem to figure out how to get the second table to expand and contract based on what's autopopulated.
Example:

Sheet 1:

Job List
JD | 111 | ACME
JD | 112 | CORP
JD | 113 | ACME
NM | 114 | RUBY
NM | 115 | PLUM
JD | 116 | ACME
JD | 117 | ZCHR


Sheet 2:

Rep's Initials: JD
111 | ACME
112 | CORP
113 | ACME
116 | ACME
117 | ZCHR

However when NM is chosen, the table stays like this instead of adjusting to the smaller number of data populated:

Rep's Initials: NM
114 | RUBY
115 | PLUM
___ | ____
___ | ____
___ | ____

Any help is greatly appreciated!