Hi Lisa,
Your Statement Group should have ten elements on it, one for each tab in the Workbook if you want to print a tab for one specific department.
So, add the same financial statement 10 times. The first time, select the first sheet and "*" for consolidated. Then, add another element to the Statement group, selecting the same financial statement, but this time the second sheet in the group and the department you want it to print for. Repeat this process until all the sheets have been selected.
The Excel workbook created if you export the Statement Group will have the name of the Statement Group, and the individual sheets in the workbook will have the names of the sheets exported.
_________________________
Andrew Bates