How to have data automaticly transfered from sheet 1 to sheet 2 when its labeled "IV"

Hello Microsoft Excel experts. I have a question and I really hope that you can help me out. I would appreciate it so much. My business requires me to dial names and phone numbers all day from a list of leads in Microsoft Excel. I use verious disposition codes for each phone number I dial such as...

WN = wrong number
NQ - Not Qualified
IV = Invite
SA - Sale
DNC = Do Not Call
UA = Unavailable
AM = Answering Machine

What I would like to do is apply a function to the disposition column so that when I label a lead as "IV" the information will automatically be copied to sheet 2.

Please click on this link to get a microsoft excel list of leads that I've already dialed on and has dispositioned applied to it so that you know exactly what I'm talking about.