An interesting Task

Hello,
I have a main worksheet, that is from suppose operation department which contains the daily record of all employees who are present same like attendance register and all employees are at one work book. And in account department I have one worksheet against one employee to calculate its monthly attendance and so they can process it salary as per his attendance. Now I want a way that those individual sheets will be updated from the basis of man worksheet data. Is it possible to get results in other sheets while data is in another sheet