Pulling information to the main file from different files

Hi Guys,
Wondering if you could help me
I design a worksheet to capture the observation by different managers. Almost 10 department need to add or update their observation in this file but the problems I am having are
1. if some managers in 10 department need to update this file, they have to wait until it is closed by another manager in another department or same department
I suggested to have different file for different department, Production, sales, logistics, which is than feeding into the “Main file”. As far as I know, Macros could help to update main file by pulling information from the different files for 10 department, but do not know how to do it, any suggestion.
Below is attached file for further understanding and this post is also posted on "http://www.mrexcel.com/forum/showthr...ain+file+files
Any help will be greatly appreciated
Cheers