title: Generate multiple Excel workbooks from pivot table
body: <p>I am new to Excel Pivot tables and need an expert advise.</p>
  
  <p>I have a Pivot table that can be filtered by multiple units. (say unit 1, unit 2, unit 3 etc...). I want to create multiple excel worksheets from this pivot table and each worksheet should contain information about only one unit. (for example, one worksheet will have data for unit 1 only), second will have data for unit 2 only etc..</p>
  
  <p>I did some research and used "Show report filter pages" which creates multiple tabs but I notice that each tab contains data for all units.</p>
  
  <p>Can anyone help me with this..?</p>