Filter table based on ActiveX Checkbox

Hello all,

I typically try to stay out of the realm of VBA due to my lack of knowledge regarding it, but for my current application I believe a little coding may save me a lot of future hassle.

Attached you will find an example of what I am trying to accomplish. I have found bits and pieces of possible ways for this to work around the internet, but cannot post them here as per the forum rules (for what it's worth, I tried some of the suggestions but to no avail).

Basically, I have a table on Sheet2 that I would like to be able to filter based on selected ActiveX check boxes on Sheet 1. However, the table on Sheet2 has some fields that are updated dynamically based on data validation from Sheet4, so I would hope that there is a solution that is flexible to account for that.

I am willing to work with limited information to produce a first attempt of my own; I just need a push in the right direction is all.

Hope I was clear, and thanks in advance for any help!

To answer both questions simultaneously, yes - I'm trying to essentially use autofilter, but instead of selecting the column headers and filtering that way, I would like to use check boxes instead. This is for a front end sheet that the user will navigate instead of going into the database we have setup on the second sheet to retrieve data.