A1 HAS A DROPDOWN LIST OF FIRST NAMES
HOW CAN I CORRELATED THIS LIST STEP BY STEP THAT WHEN
I SELECT ONE OF THE FIRST NAMES ON THE DROPDOWN AUTOMATICALLY
WILL FILL UP B WITH LAST NAME, C WITH PH NUMBER AND D WITH ADDRESS
FOR EACH INDIVIDUAL IN MY DROPDOWN LIST ( TOTAL OF 60 ). TX
PS: I RATHER NOT USE MACROS.