Pivot Table range across multiple worksheets

[deuxo]

I am trying to determine how to execute a pivot table where the data is in several data sheets. I don't want to add the cells, I want to define the range over multiple sheets. Also, do all the column headings need to be the same? thanks.

 

[Mark W.]

The data should be in a single list.