A common pivot table question is "How can I create a pivot table from data that's on separate sheets in my workbook?

Sometime people have a workbook set up with a separate sheet for each region, or for each salesperson. Eventually, they want to pull all the data together, and create a summary report in [...]