Generating reports based on conditions

Hi All,

Please find the attached sample file..

I'm trying to generate some reports or filtering of data based on conditions,when i select from the drop down menu
from the validation list,(G6:I6),i need to know whether is it possible to generate it on a new work sheet which i could
view or print and then close it with/out saving.

conditions for the reports: If category field is there (say like tyres) and the other two fields are empty (H6 & I6)then it should populate all the datas based on tyres and if H6 is "Bridgestone" then it should narrow it down to the two conditions,if I6 is "In Stock"or any other terms it should
narrow down the datas which meet the three conditions..

From the other side also if i select only "I6 or h6 " then it should populate all relevant data, with the other two conditions being nil..

Any solutions..

Thanks,
Ak