Store the values in next sheet

Dear All,
I have doubt in xl sheet, I have two xl sheet , i show the first sheet parameter as below,
CABLE NO -1
LOAD -18.5
VOLTAGE -415
CURRENT -37
EFFCIENCY-0.9
if i enter cable no is 1(assume cell is sheet1 B4), then the all values( voltage, current...) is store in next sheet row one(b1,c1,d1,e1 of sheet2), then if i enter the cable no is 2, the corresponding values are store in row 2(b2,c2,d2,e2) of the next sheet, don't over right in first row values, if i enter cable no is 3, then store the values in row 3, please help (either in macro or xl)
Thanks
Jagadesh