auto update on seperate sheet

[ajitsingh]

hello there
i have a problem if anybody could solve.
i have 9 departments each having approx 100 people, each department is on separate sheet each sheet has following columns.
name, leave_from, leave_to, type_of_leave, days_of_leave. present/leave

now what i am trying is if person is on leave his name should appear on separate sheet, the name should appear when on leave and get removed when the person has returned from leave. that is i get list all person on leave on one sheet.

regards

 

[ajitsingh]

have posted this on excelbanter also