2010 Pivot Tables with data from multiple worksheets

[Noddy13]

Hello All,

Could some please advise how I go about creating a pivot table using data from multiple worksheets. All column titles are the same however row titles are not. Is this possible?

Thanks

 

[Smitty]

See: Excel Pivot Table Tutorial -- Multiple Consolidation Ranges

HTH,