Pivot Table using data from multiple sheets

[nabanco]

Is it possible to create a pivot table using data from multiple sheets within
the workbook? For example, pivot sheet 1 a1-a12 and sheet 2 c1-c5.

If so, how do you do this? I keep coming up with errors.

Thank you

 

[ryguy7272]

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

As an alternative, you may want to create a summary sheet, and build your
pivot table off that:
http://msdn.microsoft.com/en-us/library/cc837974.aspx

HTH,
Ryan--