Exporting data to new sheet with conditions.

[jlokesh16]

I have sheet1, where there is a table in below format.

A	B	C	D	E	F	G	H
Prop ID:	Leads ID:	Caller Category:	Duration:	Type:	Name	Date	Link
ONI10P07	7631565	Prospect New	5	Phone	Jack Hill	09/04/2018	www.google.com
ONI10P07	7631578	Prospect Followup	20	Phone	Jack Hill	09/04/2018	www.google.com
ONI10P07	7631581	NonLead Resident	35	Phone	Jack Hill	09/04/2018	www.google.com

<tbody>
</tbody>

In sheet2, i have the below table:

A	B
Category	Times
Prospect New	3
Prospect Followup	2

<tbody>
</tbody>

I am looking for a macro, when i run it, the categories defined in sheet 2 should search in sheet1 col C and export the number of entries defined per user (User name in F col of sheet 1)
EG: Category 1 (Prospect New) will search 3 random entries in Sheet 1 Col C for Jack hill, and export 3 random entries containing Col C as prospect New Name as and Jack Hill. The user name list is in Sheet 2 Col D.