Excel 2000

We are conslidating a worksheet for the annual achievement in our department. We are looking for a way to make sure that all department members fill all the cells within that active part of the worksheet so that they should not leave any blank.
Is there any way to make Excel look after this job.