I have 7 sheets that contain contact information. I want to have a
filter set up on another sheet that will allow me to select a city or
a state and return all the individuals that meet the criteria from all
the sheets into this one sheet. All the sheets are formatted with the
exact same column headers. Thanks for your help in advance.

Scott