Hi all,

I am currently trying to piece together a document at work in which all our major projects identify their interdependencies upon one another as to proactively monitor risks.

I currently have 12 sheets, each labelled by the project reporting the ID. So, in sheet ABC, column B "Project" will be "ABC" for every single row. However column D will be the project ABC is dependent on, so for example 123. So I can clearly see what "ABC" is dependent on.

The problem is that I want to have a sheet whereby I can simply run something, that will locate "ABC" in column D, thus pulling every row from every single worksheet that matches that onto a new worksheet, which will show me everything that is dependent on "ABC".

Is there a way to do this? It's worth noting that this sheet is constantly being updated and is available on share point, so the user using the search formula will use it for different project codes.

Let me know if I haven't explained it well enough.

Cheers,
Matt