Excel 2007 : Excel Macro to update Column1 of sheet1 with names in SHeet with equal based count

Hi

I need assign work to my employees.

Take count based on column 2 of excel sheet1 and populate names of employees present per sheet2 in column1 of sheet.

Thanks
John

After it has to be as below:
Name Data1 Data2 Data3 Data4
John1 Data1 Data2 Data3 Data4
John1 Data1 Data2 Data3 Data4
John1 Data1 Data2 Data3 Data4
John1 Data1 Data2 Data3 Data4
John1 Data1 Data2 Data3 Data4
John1 Data1 Data2 Data3 Data4
John2 Data1 Data2 Data3 Data4
John2 Data1 Data2 Data3 Data4
John2 Data1 Data2 Data3 Data4
John2 Data1 Data2 Data3 Data4
John2 Data1 Data2 Data3 Data4
John2 Data1 Data2 Data3 Data4
John3 Data1 Data2 Data3 Data4
John3 Data1 Data2 Data3 Data4
John3 Data1 Data2 Data3 Data4
John3 Data1 Data2 Data3 Data4
John3 Data1 Data2 Data3 Data4

Thanks in advance