macro to filter all tables in workbook based on the given figure

I need to create a macro to filter all tables' different worksheets (Last year Sales ,  Open customer orders , Open orders to vendors ) in the attached workbook based on the given value in attached w...