Sum when matching a column and returning two values on a seperate sheet...

I want to output in another sheet:

When the week equals the current week (lets assume its 201421), then sum up each QTY of colors...The return data would look like (as example)

Colors Qty
Black 55
White 23
Red 12
Brown 11
Yellow 5

Im going to have this be a macro so i can use it each week with different data.