How can I pull the data out of this list into a spreadsheet

[C.j.]

I have a list of cities and counties in KY. I need it to pull the data for each city or county and list it out on a row in excel. So at the end I would have the name of the entity, the county clerk name, address, city, state, zip, phone, website, and population. I put a red square around the info I need for the first few items but I will need a formula to pull the entire sheet.

[davesexcel]

Check out the autofilter

[C.j.]

I don't think that would work. I need to run a formula that says if there is a word in blue or yellow then pull the below 6 or 7 cells into the spreadsheet.