Hello, I am building a spread sheet for a multi gun shooting competition. I have each tab for the months built and they rank properly but now what I am looking to do is build a page that will search all twelve tabs and pull only the names/ranking of people that shot in 6 matches or more. Is this something possible? So basically I would like it to pull Mike because he was ranked in 7 out of the 10 shoots. Then it would ideally pick the 6 best ranks and give him a total for that.

Any help is much appreciated. I can supply you with the spread sheet if you would like to take a look.

I don't know if it is possible but I think it could be!

Thanks a bunch