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 workbook. or I need to filter all tables in different worksheets (Last year Sales ,  Open customer orders , Open orders to vendors ) when double click on the item code cells in the "data" worksheet. can anyone help me to do this in this worksheet itself