Data collector sheet

[bittu2010]

Hi ,

In my team there are 15 people and they daily work in excel MIS and next day I have to pick ( copy and paste ) their data one by one for reporting.

Is there any macro so that I can get their data one by one on one click.

Like person A has worked in 5 Rows but person B has worked in 15 rows then I need copy only the only 5 row from person A’s excel MIS and 15 rows from person B’s Excel MIS not the blank rows.

Please suggest and let me know if you need information to create this.

Thanks & Regards

Bittu