How to hide/unhide rows based upon cell value from another worksheet

[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)

I'm sure that a macro can do this. I need the macro to be private, which I'm having issues for it to automatically hide & unhide as data is entered or deleted.

Any help would be greatly appreciated! Please ask if any clarification is needed! Thank you.