Making a Filtered Professional Learning Sheet

I keep track of all my PD learnings on a Google Document. After 16 years, however, this document has become very long. I wanted to somehow make it shorter -- I guess I could make a website -- but it seemed like a good way for me to test my Google Sheets skills.

Dynamic Dropdown menus work by matching data to the dropdown menu name where you would need a seperate sheet to keep the data.

I have two tabs on this sheet. 

=ARRAYFORMULA(IF((B4="All")+(B4=""), 'Professional Learning Data'!A2:E, IFERROR(FILTER('Professional Learning Data'!A2:E, 'Professional Learning Data'!F2:F=B4))))

In order to search both tags, I needed to filter both columns using this part of the formula:

FILTER('Professional Learning Data'!A2:E, 'Professional Learning Data'!F2:F=B4.

This works pretty good, but in order to make it work, I need to give full access to the sheet to anyone. That's why I am trying to turn it into a website.

Professional Learning Website

Thomas Hammerlund Professional Learning and Professional Development