Making Drop down list that displays data sourced from web

Here is what I need to do:

Create a dashboard sheet that allows you to select one of five stocks from a drop down list. When you select one of the stocks, the dashboard should automatically pull the CURRENT stock information from the Internet.

I know how to get the external data from the web but I am struggling with how I create a dropdown list or "dashboard" that will only display the selected data.

PLEASE HELP

Thanks.

Here is the workbook. If you go to the third tab, there is data that is pulled from the internet. I need to make a dashboard with a drop down list to display each stock respectively. How do I do this?

Yes.

Under the "External Data" tab in the workbook there is data that is pulled from the internet using the "Get External Data" section under the "Data" tab. I need this information to be displayed when selected in a drop down list. For example,if I choose IBM in the drop down list, I need all the information that is currently displayed on the "External Data" tab to appear in the dashboard that needs to be created. I cannot figure out how to link the information to the data validation drop down list to display in a dashboard like that.

Does that help?