Auto Filter and copy the specified number of rows into another sheet.

Hi All,

I need a help regarding the below issue which i'm facing while automating our bill issue system.

I have an excel sheet where the tasks done by multiple users is tracked. The tasks are categorized into two types Critical and Non Critical. At the end of month a random Check is made in the total work done by each user. That report is generated from the system automatically. From this we need to pick the specified number of bills done by each user in both critical and non critical categories and paste the data in separate sheets. This is a time taking process as the number of users are more.

I need a macro that pulls the specified number of records from the total records user wise and paste it in a different sheet (i.e critical in Critical Sheet and Non Critical in Non Critical sheet). I want to know if this is possible with Macros or Not

Please find the attached excel sheet for quick reference.

Thanks in Advance