I would use much simpler approach:

You need a sheet Organizations with columns like
OrgName, OrgPhone, OrgSite, OrgState, OrgDistrict, OrgCommunity, OrgStreetNo, OrgSuiteNo, OrgZIP

and you need a sheet Persons with columns like
PerName, PerPhone, PerMail, PerState, PerDistrict, PerCpmmunity, PerStreetNo, PerSuiteNo, PerZip, PerOrganization, PerTitle, PerNotes (you can have additional columns from Orcanization sheet calculated also, when you feel you need them).

On sheet Persons, in column PerOrganization the organization is selected from Data Validation list, based on dynamic named range defined on base table in sheet Organizations.

For table Persons, autofilter is set.

User activates sheet Persons, and sets autofilter for column PerOrganization. After that user sets autofilter for column Person (only persons from filtered organization are displayed) to wanted person(s). The info for only selected person(s) is displayed.

The same functionality you described, only 2 sheets needed, and only 2 steps to find wanted person (or any number of wanted persons).


And when the displayed row is too wide, then you can add a Report sheet. But this will complicate things considerably! On Report sheet you select organization from one Data Validation list, a person from selected organization from another Data Validation list, and all info about selecte person is displayed in more compact form. In this case you must have some hidden columns in Persons sheet with formulas to enumerate rows with PerOrganization equal with one selected on report sheet, and to enumerate all rows in Persons table, and a hidden sheet, where a list of all persons from organization selected on Report is calculated (you have to use INDEX function on Person column with number ot table row with #'th number of person of this organization in Pesons table as 2nd parameter) . On this list you create a dynamic Named Range to select person on Report sheet.

My advice is - try 2-sheet design at start.