Need to extract some data from master sheet into another sheet

Hi,

I have a master sheet having all the purchase records for long.

I need to extract data only for a month or specific period.

I have more than 20 products and around 15 suppliers.

I may not purchase all the items for all the months from all the suppliers.

I need a consolidated report.

Can some one helping me out to do this.

Originally Posted by RudiS

How about a Pivot Table.
It makes things very easy and no need for manual calculating....

Thanks for your effort.

But, it is highly helpful if you can assist me to get the report in the attached sheet.