Find all instances of a selected item and return all results

Hi NewGuy OnBlock and welcome to the forum.

You need to make your list a table or add auto filter dropdowns. Then you will click on the Item dropdown and select the one you want. After doing this only rows with that selected item will show.

see the attached and dropdown the item header.

Is that what you wanted? No code and no formulas either!!