Help using pivot table

So i need help writing formulas that pull the data from sheet 1 to fill in the information on sheet 2014. the formula has to be date sensitive and include the total sum of the main category. another point to make is that although the main category (i.e callaway, titleist) are the same in company name they each have different sub categories that place them in either apparel, clubs, balls etc. I need the formula to be indifferent to the sort of sheet 1 (i.e. dont just use sum of cells) because i may need to change the sort of the sheet from time to time.

attached is the doc

Please help

P.S. I guess a pivot table would be of use as well if someone can tell me how to do that for sheet 1 data