I'm using Excel 2003.  My spreadsheet has 9 Department tabs, each with 10
Funding Source Categories columns and 20 Expense Category rows.  Not all the
Departments use all of the Funding Sources or Expense Categories.  I have a
Master Pivot table based on all Departments combined:  Departments are pages,
Categories are columns, Expense Categories are rows, and data is sum of $.  I
want to pull the Expense data from the pivot table within each Department,  
based on the Categories actually used by that department, and I want to use
the same formula for each Department's layout (for consistency).   I have
copied the master pivot table to each of the department tabs & am showing
that particular department, but since not all pages of the pivot table
generate all the rows or columns, I'm stuck.  Any and all assistance would be
greatly appreciated - Thanks!!!