Read up on Multiple Source Pivot Table reports:

http://office.microsoft.com/en-us/ex...010226585.aspx

http://www.contextures.com/xlPivot08.html