Apologies I don't know how to title what I am looking to do. Table with buttons that filtr

Good Afternoon

I am looking to recreate what is on the attached sheet. The item I am looking at was created by someone else and I do not know what it is called so that I can reproduce it. On my inventory sheet there are three tables at the top. The first table is labeled Location. The information inside of it is associated with Column D which has a header named location. If I type a word into a cell under location, that word appears in the location table. If I click on that word in the table, it filters the spread sheet by the data/cells/columns/rows associated with the word.

An example is row 6 in column c I have the word ammo it is associated with row 6 columd d which says ID Lab. The table above shows ID Lab. The same two columns, in row 7 show Swords and ID OFFICE, and then in row 8 it shows Knives and Evidence Bay. I can click on ID LAB, ID OFFICE, or EVIDENCE bay and it will only show the data associated with the row which lists that key word. I have this set up for location, condition, and then a blank table associated with column G. I would like to know how to create these tables with their functions so that I can replicate if needed.

Thank you in advance for any help

This was exactly what I was looking for. Thank you for your expedited response.