Is this what you are looking to do?

Excel 2010 Tutorial Consolidating Data Microsoft Training Lesson 19.1 - YouTube