Excel VBA/Macro coder needed

Currently I have an Macro-driven Excel sheet filtering a spreadsheet of data based on multiple front-end buttons, each applying a filter to a different column of data. This allows for 'AND' logic - where one line of information meets the criteria for two or more buttons, applying two or more filters.

However, upon development we now need to change the relationship between filters from AND to OR - when multiple front-end button are pressed, the results sheet needs to display all entries that meet any of the selected criteria.

Additionally, a new drop-down menu needs to be added to allow for filtering from a range of options in another column of the spreadsheet.

Working version of the file available on request.