Ok, heres the scenario.

I have an excel workbook that is basically a risk & issue log.
I have 4 work sheets in the work book - all are identical except that they
display data blonging to different projects.

What I want to do is have a "front" worksheet that will just display the
"open" items from each of the 4 workbooks.

Any ideas if I need a function, or perhaps a macro?