New to excel , need help!

  I would like to transfer information from one sheet to another, such as.   If I have sheet 1 with A1 = Chad, B1 = 1, C1 = 2, D1 = 3; sheet 1 with A2 = John, B2 = 4, C2 = 5, D3 = 6   If I ...