Bea has attended:
Excel Advanced course
Pivot tables
How to effectively summarise info in different worksheets or event different files
RE: pivot tables
If the data is laid out in the similar manner then the best feature to use is Data > Consolidate...
Hope this helps!!