Need to create an IF statement that pulls data from table populated by a drop down menu

OK. Here's the deal. I need to have an IF statement that pulls data from a table on another sheet that uses a drop down menu to populate the entire table. The attached file is a MUCH simpler version of what I need to do. NOTE: both sheets have data on them.

Can an IF statement pull data based on a drop down menu and show everything at the same time? Not just the one from the current selection on the drop down?