Hi
I would suggest you create one workbook for each department.
The create a Master Workbook which you only have access to. You could then have a separate Worksheet for each department where all the data you want to see for each department is linked for each department.

For example:
You have a separate workbook for Dept 1.
You open the relevant worksheet in the Workbook for Dept 1 and select Ctrl+A to select all of the data on that worksheet.
Then select Ctrl+C to copy the data.
Go to you Master Workbook and select the worksheet you have earmarked for Dept 1 and right click in Cell A1 and select Paste Special.
Then Select Paste Link.
This will link the data from Dept 1's workbook to your master.
Any changes in the worksheet for Dept 1 are automatically updated in the Master without the master being open (as long as they are on the same network).
You can do this for each department.
Hope this helps.
Good luck.
Tony