Automatically copy and paste a row into a new worksheet based on a value

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

I have attached below.

So if we take Project A, I can see everything that A is dependent on to deliver the project.

I want to run something in "Run Lookup" sheet that will draw all the rows from across the sheet that contains "ProjectA" in column D. This will the create a view where I can see everything that is dependent on Project A.

Hope this makes more sense.

Matt

Honestly Sir, you are an absolute God of Excel I have been trying to do this for so long!

So no matter how many new sheets I create, it will no impact it as the macros are set to ignore certain pages, as opposed to including? (I am a complete rookie at this!)

Matt