If you want this "summary table" to be a seperate table from the original, then that changes everything. Especially if you want it to automatically update.
Here is an answer for a similiar issue that should help you: http://www.excelforum.com/excel-char...23#post3124223