How can I generate categorized lists in Google Sheets or Excel?

Other Questions Google Sheets
1

I want to dynamically display separate lists for media, health, and eyes from tagged data in a spreadsheet, each on distinct tabs that update with new entries automatically.