I have five excel sheets being filled up by five different managers for
monthly attendance of staff alloted to them from time to time. On the month
end I need to merge all these data in one sheet and produce a consolidated
report on the attendance status of each staff.

Please note that one staff is alloted to various managers on different days
and all the sheets are in same format i.e. column 'A' is having the names of
all staff members. Further columns are manually put in dates of a month.
Sharin of this workbook will not be possible.

Can any body help me to merge these data in one sheet??

Run this macro every month
http://www.rondebruin.nl/copy2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Sudip" wrote in message ...
I have five excel sheets being filled up by five different managers for
monthly attendance of staff alloted to them from time to time. On the month
end I need to merge all these data in one sheet and produce a consolidated
report on the attendance status of each staff.

Please note that one staff is alloted to various managers on different days
and all the sheets are in same format i.e. column 'A' is having the names of
all staff members. Further columns are manually put in dates of a month.
Sharin of this workbook will not be possible.

Can any body help me to merge these data in one sheet??