If I'm understanding you correctly, you would either copy or create the sheet for the 1st division (removing all other division columns) and then copy to add'l sheets swapping out the tree/division in each sheet. So in essence you have a consolidated and then if you have 5 divisions, you would have 5 more worksheets in the workbook. For distribution you can indicate to create a file for each worksheet (bursting?).
If you're really good with Macros, I have seen where you would create the 'master' division sheet (for 1 division) and then use a Macro on a Prompts Page to read the tree divisions (on the prompts page) and create a sheet for that division. This Macro would be run after the report has been run or as part of the running. It does then keep the maintenance on the individual Division sheets down as you only maintain the 1 along with the consolidated. I'm not a Macro Person, but I've seen it done and it's pretty neat and something I need to figure out myself.
N
------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN
------------------------------