Macro to copy(based on criteria) to a different work book

[kris21]

Hi Team,

Can you help me with a macro for copying data based on criteria to a sheet in another workbook?

I have an excel sheet with columns from A- O. I want to filter the data in columns M,N,O and copy the data.
ie. I have locations in column N(4 diff locs),Tool names in column M (8 diffnt names)and Tag in column O(only two values). so if I have Mumbai in column N , Wrench in column M the data from column A-L should be copied and pasted into sheet named(specific area) "Wrench" in "Mumbai workbook".

Thanks in Advance !!!!