I can't seem to run a pivot table across multiple sheets of data. All of my
sheets are formatted the same way. I've gone ahead and started the pivot
table and then when I select the data, I've tried to click on the sheets one
by one while holding down the shift button. I get the error message, Data
Source Reference is Not Valid.

So then I go through and manually select the data range for each sheet, but
it seems that I can't build the list. When I run the table it just includes
the data from the last sheet that I selecte. Please Help!

--
Nick MMG