Extracting Specific data to new worksheet

[CentaurSaratoga]

In reference to ExcellsFun's video on credit analysis: http://www.youtube.com/watch?v=-ndPtw3I790, I downloaded his workbook "Week 7 Business 214" downloadable here:
http://people.highline.edu/mgirvin/ExcelIsFun.htm

and would like to extract "only" those "accepted" with customer id # and asset value to another worksheet (in same workbook) for further analysis (solver). How can I do this?

Thanks!