addnew record automation
 

I have two worksheet in one workbook.

Worksheet One - Contact Master
Name Postion Phone Adress E-mail

Worksheet Two - Master Schedule
Name Position

Whenever I enter a new record in the Contact Master, I would like the new
record to automatically enter into the Master Schedule, where fields are
applicable. Is there a formula, code, or macro that I can use to accomplish
this?