Checkboxes in one sheet to control report filters in pivot table

Hello! I have been a lurker around these boards for a while and all the information has helped me tremendously. I have a project at work which involves training schedules for employees.

Right now i have 5 major filters for the reports 1) Complete/Upcoming 2) Due 3) Due Soon 4) Enrolled 5) Overdue. There options are on a master page with Form Control checkboxes. They do not have anything yet in the code.

I have a second spreadsheet which already has a pivot table set up with the report filter option which should change based on which checkboxes get selected. The end goal is to hide the filters and lock the sheets and allow the user control only from the master sheet as to avoid anyone creating any discrepancies.

I am looking for some guidance or if anyone has any code that I can use to make some of this work.

Thank you very much!

I think Slicers will do what you looking for.

Never heard of slicers. Let me look into them and see if they do the trick. Thanks for your quick response