Hi,

I recently got promoted to a position of data analyst because I know a little excel. Our workers here input all their worked reference numbers with their queue description in different excel sheets on a daily basis and they are linked to a single sheet. So its like each person (like a 100 employees) has to fill a workbook with 31 sheets everyday. It is really congested and I was wondering if any one of you all have a simpler format and if there is any macro which could help me summarize the data on a daily basis on a different sheet. I don't know if I am making sense here but looking forward for some help.