Searching Values that Follow a Specific Format and Copy Rows to a New Sheet

Hello VBA Gurus:

Please write a VBA code that do the following tasks:

Pseudo Code:

*This code applies to Quote Summary sheet ONLY.

1, Create a new sheet on the next available tab and name it "Quote Summary(DHC-8)".

2, Copy the first row of "Quote Summary" to the sheet "Quote Summary(DHC-8)".

3, Start from Row 2, if cell A2 has the format " 8xxxxxxx-" (Before "-" : all number, starting at 8, 8 digits ; After "-" : number and letter , can be any length), then copy row 2 to the next available row on the sheet "Quote Summary(DHC-8)".

4, Repeat until the end of the sheet "Quote Summary"


Sample File
Process Sample 7-Get Dash8 Parts.xlsm


Thank you and I am looking forward to your response,

Chris