A. You would need to view each department as a separate Pivot Table first, then copy the worksheet to its own tab
B. Options contextual tab, Options icon, Show Report Filter Pages, OK
C. Display all departments, Options contextual tab, Move Worksheet icon, choose \New Worksheet\, OK
D. Design tab, Move Pivot Table icon, \Move to Individual Worksheet\, OK
E. I don t know the answer to this question.