In Excel 2003 I was able to combine more than 10 tables' data in one pivot table through "Multiple Consolidation Range". I cannot find the option in Excel 2007. Any ideas?
I believe you can press Alt+D and then P, which will open the PivotTable Wizard as per previous versions of Word.
From there you can use the Multiple Consolidation options you require.