In Excel how can I sort data from one sheet and use only a portion into another sheet?

I have a full list of data sorted by county on sheet 1 in Excel. I'd like to create other sheets having the same data but just by one county per sheet. Will VLOOKUP do this and how? Thanks
2 answers 2