Copy rows from multiple worksheets with multiple criteria - greater than dynamic values

I have code that successfully extracts rows from 83 worksheets into a master worksheet based on one value being greater than a number in the code. I would like to be able to look up 3 (or more) values that can be pulled from a cell in the master worksheet that I can change as the project demands. The values are numeric and not integers. Here is the existing code which I pulled from another forum post. Generally speaking, I have no idea what I'm doing:

Please Login or Register  to view this content.

There same rows appear multiple times on the same sheets (e.g. sheet2 has the identical data on two rows) and there are empty rows. I'd like it to only output that row once if possible.

Thanks a ton,

Andrew

Update. I figured out how to look up multiple variables and how to pull the variables from cells, but I am still want to limit my output to unique rows. Looking at the attached example, I want to be able to create a list of all places with a population between 25,000 and 250,000 with median household income less than $48,308 and with more than 17.2% of the population with a "ratio of income to poverty level" at "percent 0 to 99." The attached sample workbook county econ data example.xlsx shows that I am getting the correct output, but I want it to cull the double entries from the source worksheets.

Here is up my updated code

Please Login or Register  to view this content.

but I want it to cull the double entries from the source worksheets.

Since you loop through each worksheet you could perhaps add a line like this?

Please Login or Register  to view this content.

I've tested this on the "MergedData" sheet to get rid of duplicates. The the start point A3 is where the headings is, modify if needed.

Alf