Filter one column with multiple checkboxes to multiple data tables

Hi All,

I'm still fairly new to VBA and macros so apologise in advance if I sound waffled to begin with.

So, what I need to do is, filter one column based on what checkbox is selected. My worksheet has data separated into 7 tables of data (Sales Divisions), but I want the filters to work over all 7 tables simultaneously.

I have several columns, but only want to filter data by one of the columns depending on what Sales Stage is selected. i.e if the "PP&O" checkbox is selected it shows only those with PP&O in that column, same if "SUB", "OTHER", etc. Also with an ALL checkbox which shows all data.

Can someone help me figure this out, I can attach a sample workbook if its easier.

Thank you!

?
some example maybe ?