Compiling a list from a long set of data

[dbs179]

Hi,

This is my first post on here, but I have looked over alot of posts yesterday to try to figure out the problem I am having. I have a workbook set up to compare a list of numbers from one sheet to three lists on three other sheets. I have worked thru that by doing some research here as well as a few other sites, but now I would like to add a new worksheet to give me a compiled list of all of the numbers that show up as "closed". I tried using one of the examples on here that I saw but was unable to get the offsets to work properly. The biggest problem, is that this list when it is done can be over 1000 rows per sheet, and it is a hassle to scroll all the way thru just to see which numbers on the "Master" worksheet are closed.

Any help with this, or suggestions would be greatly appreciated.

Thanks

Dave