To get desired data in master sheet by selecting required item in drop down list

Hi Friends,

Please help me out.

I have one excel workbook which has 4 sheets present in it with each sheet having total 56 items.
Please help to create a drop down list where i can just select any required item in the master sheet and all its relevant information in other sheet can be collected in the master .
Also if i want to update more sheets in workbook with different information how can i add the information in dropdown list later on.

This data is regularly updating and not constant , so is it possible if i add or delete information in the sheet and it will get auto update in the master sheet.

Please help me on this queries.

thanks in advance