How to find customers which purchase particular product

Dear All Masters,

I have an excel sheet in which I want to find the those all customers and their customer type,product basic price and monthly volume who purchase that particular product, based on it's item code (item code which will available in Master sheet cell A3).

And all the data which has to be find, is available in DEALER DATA sheet.

I have attached sample sheet for your reference.

Kindly do the needful

Thanks in advance.

Dev.