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