Excel 2007 : Autopopulate master sheet based on other sheets in workbook

Hi guys,

Can you please help me out with this one.

I need a master sheet that will populate the data in the sheet based on other sheets in the workbook. These sheets will have the person's name as a name, and on the master sheet you will see the drop down box with their names.

As you select a name from the drop down, I want the tables below to autopopulate.

Can you help me with this please!

I thank you all in advance for your help