Thanks for your concern Bala, we are not through to what we need but very near to it.
When i enter code eg. WC1, all the rows that contains WC1 gets copied to a a new Sheet 1.
Now, i need a code which gives me an option of choosing PL or SA1 OR SA2 in Sheet 1, which should also copy rows that contains one of these options to Sheet 2.

Thanx, for your concern once again awaiting for your earliest reply..