There is a feature in Excel called 'advanced filter' which is quite powerful for data extraction.

Below is an example of extracting data in a different worksheet by using advanced filter.
Extract data in different worksheet



Homepage
MS EXCEL TRAINING