Macro to rotate through list of names (advanced)

[bdone]

if you look at the table below, there is a date column and a name column. in a perfect world, i want to copy a list of names to my clipboard and run this macro. the macro will paste the contents to sheet1, convert as many names as i paste to a table, then on sheet 2, create these two columns for the length of a year with each week being every 3rd interval (as below), and start pasting the names through the list. the problem is that when kevin shows up the 2nd time, i need him to be in spot 2, nate to be in spot 3 and brent to be first. this way my engineer isn't on first call priority everytime. if it makes it easier, i currently have 24 names, but would like it to just work off my clipboard contents. can a genius make something like this?

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]week[/TD]
[TD]Engineer Name[/TD]
[/TR]
[TR]
[TD]3/6
[/TD]
[TD]kevin[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]nate[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]brent[/TD]
[/TR]
[TR]
[TD]3/13[/TD]
[TD]darren[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]dimitri[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]doug[/TD]
[/TR]
[TR]
[TD]3/20[/TD]
[TD]jody[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]matt[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]tom[/TD]
[/TR]
[TR]
[TD]3/27[/TD]
[TD]tyler[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]susan[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]gt[/TD]
[/TR]
[TR]
[TD]4/3[/TD]
[TD]janson[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]nathan[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]chris[/TD]
[/TR]
[TR]
[TD]4/10[/TD]
[TD]reid[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]allen[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]marcus[/TD]
[/TR]
[TR]
[TD]4/17[/TD]
[TD]christopher[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]cole[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]michael[/TD]
[/TR]
[TR]
[TD]4/24[/TD]
[TD]daniel[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]justin[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]thomas[/TD]
[/TR]
[TR]
[TD]5/1[/TD]
[TD]kevin[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]nate[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]brent[/TD]
[/TR]
[TR]
[TD][TABLE="width: 68"]
<tbody>[TR]
[TD="class: xl65, width: 68, align: right"]5/8[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]darren[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]dimitri[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]doug[/TD]
[/TR]
</tbody>[/TABLE]