Need a Search/Filter solution

How do I create a search function or filter to return a department or office on a spreadsheet that contains multiple organizations that all contain multiple offices and also list the billets/positions that fall under them in the order they are listed? I?ve looked at a few things online and in books, but I?m not able to come up with a complete solution. I imagine it will be a mixture of a few things to make this work right. I?m hoping that there is a semi easy quick process to carry this out.
Each organization contains a unique identifier. Organizations are arranged in a specific hierarchy. Larger department codes are listed with smaller office codes falling under them. Billets/positions are listed under all.
For example use a department store that is broken up into functional areas/departments Lawn, lumber, paint, appliances. Under lawn you may have the subsections/offices of plants, lawn care, storage and tools with five billets/positions under each.
The spreadsheet would list the records in this manner:
Hierarchy Code Title
D Department Store
E Manager
E Asst Manager
D Lawn
E Supervisor
O Plants
E Employee 1
E Employee 2
O Lawn Care
E Employee 1
E Employee 2
O Storage
E Employee 1
D Lumber

So if I wanted to search for lawn the result would be:

Hierarchy Code Title
D Lawn
E Supervisor
O Plants
E Employee 1
E Employee 2
O Lawn Care
E Employee 1
E Employee 2
O Storage
E Employee 1

This will need to be applied to a new spreadsheet that contains over 13,000 records each month that changes from the previous month.
Thanks all. Looking forward to hearing how you would achieve this.EXCEL PROBLEM.xlsxEXCEL PROBLEM.xlsxEXCEL PROBLEM.xlsx

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

It was not clear... but I assumed that you wanted to search for ONE department in ONE store...

=LET(A,A3:E26,B,A2:E2,C,SCAN("",IF(INDEX(A,,5)="D",INDEX(A,,4),""),LAMBDA(x,y,IF(y="",x,y))),VSTACK(B,FILTER(A,(INDEX(A,,2)=G1)*(C=G2))))

See file. Delete ALL expected results firts!!