Often, the data you want to summarize is located in more than one range—sometimes even in several different worksheets. If the ranges have a similar structure and common row and column labels, you can group them together for analysis in a single pivot table.
▸ See Consolidating Worksheets