The FILTER function in Google Sheets is one of the most powerful and versatile tools for dynamically working with data.

You can take drop-down lists to the next level by making them dynamic with dependent Drop-down Chips

Dropdown chips are a better-looking version of the old-fashioned dropdown lists you could create using Data Validation.