Password protection is not very secure in Excel. Why do the departments
need to see what other departments have filled in? Is one department's
data entry dependent on another department's? If not, then why not just
give each department their own file with a single sheet in it, then
when they are completed and returned to you then you can merge them
together in the way you are planning now.

Hope this helps.

Pete