You have a few options for this. You can have a single Microsoft Excel worksheet with a Vivid Reports CPM Control Panel that allows a user to quickly change the department view, you can also link multiple worksheets together that are driven off each other or a “parameter” worksheet. Automation can be used to build a set of workbooks with a worksheet for each department all from one master report layout.