Extract Data In Worksheet In Two Columns

Code through which I can extract the Name and father/Husband name from the following data in new Work Sheet in two column Name and Father/Husband Name

Cell A1 contain - Name : Ashok Kumar Father's Name : Raja Ram House No. : 1 Age : 60 Sex : Male
Cell A2 contain - Name : Renu Gerg Husband's Name : Ashok Kumar House No. : 1 Age : 55 Sex : Female
Cell A3 contain - Name : Mohd Yusuf Father's Name : Mohd Sabir House No. : 2 Age : 65 Sex : Male
Cell A4 contain - Name : Rani kishwar Sultana Husband's Name : Mohd Yusuf House No. : 2 Age : 52 Sex : Female
-
-
-
Cell A55000 contain - Name : Sudesh Father's Name : PC joshi House No. : 3 Age : 39 Sex : Female