Bulky Formula need help improving

Mail Drop Needs Fixing.xlsx
First Sheet in A1 I have a dropdownmenu that is linked with 2nd sheet (List of names)
in cell A5 i have the following formula

=IF(A3="Person 1",Sheet2!B1,IF(A3="Person 2",Sheet2!B2,IF(A3="Person 1",Sheet2!B3,IF(A3="Person 4",Sheet2!B4,IF(A3="Person 5",Sheet2!B5,IF(A3="Person 6",Sheet2!B6,IF(A3="Person 7",Sheet2!B7,IF(A3="Person 8",Sheet2!B8,IF(A3="Person 9",Sheet2!B9,IF(A3="Person 10",Sheet2!B10,IF(A3="Person 11",Sheet2!B11,IF(A3="Person 12",Sheet2!B12,IF(A3="Person 13",Sheet2!B13,IF(A3="Person 14",Sheet2!B14,IF(A3="Person 15",Sheet2!B15,IF(A3="Person 16",Sheet2!B16,IF(A3="Person 17",Sheet2!B17,IF(A3="Person 18",Sheet2!B18,IF(A3="Person 19",Sheet2!B19,IF(A3="Person 20",Sheet2!B20))))))))))))))))))))

So that when I select a name from the dropdownmenu the suburb which they will be dropping mail to will come up

In cell A7:A16 I have the following formulas all the same, just with pointed to a different cell

=IF($A$3="Person 1",Sheet2!C1,IF($A$3="Person 2",Sheet2!C11,IF($A$3="Person 1",Sheet2!C21,IF($A$3="Person 4",Sheet2!C31,IF($A$3="Person 5",Sheet2!C41,IF($A$3="Person 6",Sheet2!C51,""))))))

On my 2nd sheet I have 3 data Colums
1st Colum name of people
2nd Column Suburb Names
3rd Column Street Name


IM just wondering how I can make this easier and less bulk

Thankyou for any help or ideas :D