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.

See attached.

hi its possible with simple pivot why micro.

I would rather it be a macro, so i can paste the new data in the next week and return the results i need. It's a simple time saver, because I have to do multiple reports that are similar.