I can't do much with Excel pivot tables, but I can do a little. So I figured that telling the pivot table to use data from multiple spreadsheets -- how difficult could this be?
Ahem. The method's the same, but the results -- not optimal. Sometimes, not even comprehensible.
Perhaps I'll understand it tomorrow.