Thread: How to get the data into the cell from list.

Dear Sir,
I have one list that contains the employee names in Sheet1.
To make use of the above list in various places, i have created one Names object with the above data in Sheet1.
My requirement is to utilize the above created Names object/Employee names list into Sheet2 and that list should appear like drop down list as explained below.

Like, in sheet2 user needs to enter the values based on the column header(If the column headre is EMP NAME means user should enter the user name). In the process of entering data, when the cursor comes to employe name column it should display all the available emp names in the drop down list that shouold come from the list whatever is available in Sheet1.

It should appear in the same way for all the cells under the EMP name column .Please help me how can i achieve this.