Hi everyone,

Brand new to the forum. I'm a pretty advanced Excel user, but I'm being stumped with what I'm trying to do in this scenario and how to go about accomplishing it...

Basically, I have a Requirement Matrix that looks like the attached. Each of the projects have their own tab. This Requirements Matrix is an ever growing document, so I can't say from cells A1:Z100. What I would like to accomplish is for each project tab, pull in all associated requirements and their data points. If anyone has any other suggestions on how to structure this, I'm open to suggestions. I don't want to use Filter as I have multiple teams and would have to Re-Filter for every team (and every time a new requirement is added).

Copy_Paste_Criteria.xlsx