In Excel 2003 I was able to combine more than 10 tables' data in one pivot table through "Multiple Consolidation Range". However I couldn't seem to find the same option to do it 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.