compare and get data from many sheets and place it in another sheet

[mtsf26]

i have 2 sheets have same structure.and im going to extract any information from those sheets. sheet contain date,supplier,city of supplier,product,quality,quantity,price,no.debit, no credit. and take for example im going to find one supplier with all the quality that they have sent,or im going to find any supplier with a1 quality, and all information should be placed in one sheet??? i have attached the file too.hope you can help me.thanks in advance

[Rajwant]

i have 2 sheets have same structure.and im going to extract any information from those sheets. sheet contain date,supplier,city of supplier,product,quality,quantity,price,no.debit, no credit. and take for example im going to find one supplier with all the quality that they have sent,or im going to find any supplier with a1 quality, and all information should be placed in one sheet??? i have attached the file too.hope you can help me.thanks in advance
could u send me Your E-mail ID @ rajwant_jmv@yahoo.com. bcz attachment is being show when i reply to u.