Moving, replacing and clearing cell data while making a list of the moved items

[CastingDirector]

[TABLE="width: 674"]
<tbody>[TR]
[TD]I'm so new it hurts...but I'm trying. I just don't see this problem listed in the forum. What am I missing?

A B C F G [TABLE="width: 674"]
<tbody>[TR]
[TD][/TD]
[TD] TIME[/TD]
[TD][/TD]
[TD]NAME[/TD]
[TD][/TD]
[TD]AGENT[/TD]
[TD][/TD]
[TD]ROLE/NOTES[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD="colspan: 3"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 178"]
<tbody>[TR]
[TD="colspan: 3"][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 674"]
<tbody>[TR]
[TD]1 Confirmed[/TD]
[TD]10:00 AM[/TD]
[TD="colspan: 3"]Name 1[/TD]
[TD]PSA[/TD]
[TD][/TD]
[TD]Testing this system for the first time[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2 Not Interested[/TD]
[TD]10:10 AM[/TD]
[TD="colspan: 3"]Name 2[/TD]
[TD]Talent H[/TD]
[TD][/TD]
[TD]Testing this system for the second time[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3 Calendar Conflict[/TD]
[TD]10:20 AM[/TD]
[TD="colspan: 3"]Name 3[/TD]
[TD]WME[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Column A is dropdown list with various responses (3 are shown). I need to have A2's response of "Not Interested" automatically move the Name (C2), Agent (F2) and Role/Notes (G2) into 3 columns in rows forming a list on the sheet while "re-setting" C2, F2, G2 to become blank ready for another name to replace the now blank cell in that time slot and not altering the new list of "Not Interested"?
Here is the formula for the list of "unavailable" but I cannot create an accumulated list of the names "not interested" WHILE clearing the main sheet for new input.

=IF(OR(A2="Not Interested",A2="Available but OOT",A2="Calendar Conflict",A2="Unavailable for Audition"),B2,"")

Can you see me through this...please?