Need to pick data from main chart to 4 auto generated sub chart based on 2 criteria

Hi good after noon,

I am filling material processing transactions entry chart with Send from, send to, material name, date, dc no & quantity details as per attached excel file >> sheet name "Input data"
I want to separate those information to another 4 charts based on material name & send to cell values as per attached excel file >> sheet name "Output data"
Also i have added data validation in input data chart for avoiding any spelling mistakes in criteria columns. Kindly help me to give your valuable formula for the 4 charts mentioned in sheet name "Output data"

Dear Proton Leah,

Thank you for you quick and smart formula to solve my query.
You are simply master mind...