Generation of data in sheet 2

Hi,
I am trying to prepare an excel where
in sheet1
Column A: 'task no' are entered
Col. B: employee name will be selected from drop down against each task number.

In sheet 2
I have allready Entered the name of employees
I want below the name all the task no. assigned to that person to be genarated automatically.

Please find the attachment.

Best regards,
Tanza