Automatically adjusting rows displayed based upon data input

[swhitesides]

One sheet of my workbook is a master summary sheet where data is entered. Column A contains numbers that we use as a VLookup Reference key for other sheets in this workbook. Example:
Master Summary Sheet
1 Bob
2 Fred
3 George
4
....
105

Now, I want other sheets in this work book to only display certain rows that correspond with data input from the master summary sheet. Example
1 Bob (may have up to 15 corresponding rows listed beneath name)
2 Fred (may have up to 15 corresponding rows listed beneath name)
3 George (may have up to 15 corresponding rows listed beneath name)
4 (Hidden until data entered on master summary sheet, then
automatically displayed along with corresponding rows)
... (Hidden until data entered on master summary sheet, then automatically displayed along with corresponding rows)
105 (Hidden until data entered on master summary sheet, then automatically displayed along with corresponding rows)

All help is most appreciated!