Ok i have a list of positions with a given unique id (the id can be changed) On 52 other sheets that all have a different criteria in the same cell i will want to display every position that has the critera that is given...

I have attached an example... 1 is the data 2, 3 are result sheets

The cells in yellow is what i would need returned on those sheets
I can have unique ids changed
There are actually 52 different departments but if someone can get me started that would be great. If i need to add other items as well that is fine.Position List Example.xlsx

Thank you in advance!!!