Show higher levels based on the filter

[fizzlefrost]

Let's say I have a spreadsheet that has all towns in the world. All towns have houses in it. All houses have items inside. All those items have smaller items inside. And so on until row level 6.
I want to make a macro that based on my filter search opens all of its children. For example if I wanted to search for a refrigerators it will show me all the items inside them and items inside them as well. How do I realize it?