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

[Ravindu94]

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

[#2 · Accepted solution]

@Ravindu94 

See the attached version.

[#3]

Hi @Hans Vogelaar

this is really helpful.

thank you