I have a top level summary sheet which I would like to show the
filtered data from the underlying sheets. I would like this done
automatically so that as I filter sheet 2, 3 etc, the top "summary"
sheet shows all this information automatically in the column I would
like them to appear.

Is this possible?? Thanks...