ExcelBanter - Can a Pivot Table pull data from Multiple WorkSheets ?

Not my area of expertise, but this is what is stated in Help:

About creating a PivotTable or PivotChart report to consolidate multiple
data ranges
When you have several Microsoft Excel lists with similar categories of data
and you want to summarize the data from the lists together on one worksheet,
one option is to use a PivotTable or PivotChart report. Excel also provides
other ways to consolidate data that work with lists in all kinds of formats
and layouts.

Setting up the source data When you consolidate data from multiple lists
or worksheets, the lists or worksheets must have matching row and column
names for items that you want to summarize together. Do not include any
total rows or total columns from the source data when you create the
PivotTable or PivotChart report. Learn about setting up data in list format.

Using named ranges when source data is likely to expand To make the
PivotTable or PivotChart report easier to refresh when the source ranges
change, name each source range and use the names when you create the
PivotTable or PivotChart report. If a named range expands to include more
data, you can refresh the report to include the new data.

Using page fields in consolidations A consolidation uses custom page
fields that contain items that each represent one or more of the source
ranges. For example, if you're consolidating budget data from the Marketing,
Sales, and Manufacturing departments, a page field could include one item
for each department plus an item to show the combined data.

Page field options After you click Multiple consolidation ranges in step 1
of the PivotTable and PivotChart Wizard, you can choose the kind of page
fields you want.

a.. A single page field To display a single page that consolidates all
ranges from the source data, letting you display each individual range or
the consolidation, click Create a single page field for me in step 2a of the
wizard.

b.. Multiple page fields You can create as many as four page fields and
assign item names for each source data range, or you can create a
consolidation that doesn't have page fields. Click I will create the page
fields in step 2a of the wizard. Use this option when you want to compare
partial and full consolidations. You can assign any subset of your ranges to
a page field so that you can display a consolidation that includes only the
ranges you assign.
The text has links, so you might want to look it up in your own help file.
--
Regards,
Tom Ogilvy

"GSears" wrote in message
...
Hello;

I'm attempting to Pull data Into a Pivot table from
Multiple WorkSheets and/or multiple Pivot Tables .... Is
this possible ?

Thanks,

Greg