Excel: Extract Data onto another sheet based on Criterias

[IMG]https://www.dropbox.com/s/tgyh5imc66iia9w/Sample%20Data.JPG?dl=0[/IMG]Hi I have Data on a sheet that looks something like this:

[TR] [TD="class: xl75, width: 71"]10073301
Zip Code/Area Code Order Numbers
PT [TABLE="width: 71"]
[/TD] [/TR] MSW [TR] [TD="class: xl75, width: 71"]10073302
[/TD] [/TR] MSP [TR] [TD="class: xl75, width: 71"]10073304
[/TD] [/TR] WCP [TR] [TD="class: xl75, width: 71"]10073305
[/TD] [/TR] [TR] [TD="class: xl75, width: 48"]629613
[/TD] 10078998 [/TR] [TR] [TD="class: xl75, width: 48"]8198341
[/TD] 10078989 [/TR] [TR] [TD="class: xl75, width: 48"]129811
[/TD] 10075643 [/TR] [/TABLE] I want to extract specific data to be transferred onto another sheet. Is there a formula I can use to transfer order numbers that bear these area codes PT, MSW, MSP & WCP onto another sheet. I have a long list that runs to row 3000 and more to be updated on daily basis. So I would like these numbers that bear the above mentioned area codes on another sheet so that I could separately work on them. I would like that sheet to be updated automatically instead filtering, copying and pasting. Any help would be most appreciated. Thank you in advance.

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of September 09, 2017.

For more resources for Microsoft Excel