Sort data and past into new sheet

[nick99]

In the attached excel file you will see 3 work sheets.
Sheet 2 has data that I need to sort with respect to what's in Column D

The data in column D has three type of peculiar words:

• WK
• SRT
• XK

I need to sort this data in such a way that all the WK?s and SRT?s are copied onto the WK Sheet
And only the XK?s into the XK sheet.



EXTRA ? This is not required urgently, it?s just for convenience. If the previous step is solved I can work on the problem below.
If possible can I have a message box to sort the column the way I want to with respect to either WK, SRT, XK or the liter type of the engine?
And then paste it into new sheet with an Input box asking me to name the new sheet?

[nick99]

Sorry about the confusion,
the only way the data in that column can be distingushied is:
W stands for WK
X stands for XK
and SRT which is a part of WK

So i want to delete the rows with X in there. the problem is all the cells have the type of engine 4x4 or 4x2.....

Please can anyone help!!!