Cross sheet dynamic conditional reference

[Runee]

Hi,

My google-fu is simply not good enough - or what I am trying is simply not possible... Or need some VB code I am not sharp enough to do.

I have an Excel document with several sheets - the amount of tabs grows over time, so trying to avoid directly referencing them, but somehow to enumerate them.
On these tabs/sheets are a (also dynamic) number of rows, each with a cell containing one of three possible strings. (Think "open", "closed" "progress")

What I want to achieve, is to have an "overview" sheet, where a copy of all rows that contains one(or two i.e either "open" or "progress") of the possible strings across all other sheets is listed. It should be a dynamic reference, so when I update anything in that row on its original sheet, the corresponding row on the overview sheet is also updated.

Is this even possible or too far-fetched?

 

[Runee]

Does this work?

https://drive.google.com/file/d/0B0E_BcIIRt-lb01wcU11TW9vR3AyU19rbFdjeGFBc0lJbmVj/view?usp=drivesdk

 

[mumps]

Click here to download your file.

I have made a few changes and removed the function which created the ID's because it was creating problems. When you click on any cell in column A of any sheet, the ID will be automatically created. I have also added drop down lists for the status to make it more efficient. Give it a try and see if everything has been covered.

 

[Runee]

Sorry for the late reply here - got caught elsewhere.
Thank you so much for doing this - just downloaded the file, and will take a look today