macro to create pivot table(s) and sort out data in other worksheet

it still is not working.
the code i used is the one given by StephenR and I did not manage to modify it yet to add a condition in it.
I would like to be able to help in return but it is all here in the post... I could not go further....

actually: some info there: http://www.cpearson.com/excel/ArrayFormulas.aspx
I have just started reading it but it looks very helpful.

i hope it helps!