To consolidate contents of multiple workbook
 

Hi,

We are using one main workbook which contains 4 or 5 worksheets.The main
work book has a sheet called EBD.
This worksheet is also persent in 6 other workbooks available to different
managers at a shared location.

The managers would make changes to two columns of this worksheet i.e 'EBD'
in their respective workbooks the entire day.

At 5.00 p.m we want the access of the manager is disabled for each of their
workbooks and we want to consolidate all the changes in the 6 workbooks and
update the 'EBD' sheet of the main workbook.

Can anyone tell me how can I consolidate the information that all managers
update during the day and later on run a macro at 5.00 pm automatically,
diasble their authorization and than consolidate all in the main.

Thanks a lot.

Thanks and Regards,
Shal