Filter only records containing 'x', copy, paste in new sheet, and then delete. Please help

Hi,

I would really appreciate someone's help on this one, and thanks in advance.

Ok What I need is to be able to do the following:

1. Have a button in Sheet1 that filters a range of data in Sheet2.
2. The filter would be based on a column (the range of data) in Sheet2 that contains either a 'Yes' or 'No' only.
3. If the column contains 'No', do nothing.
4. If the column contains 'Yes', then:
4a. Filter and copy only the 'Yes' rows (including the header row),
4b. create a new sheet (Sheet3),
4c. Paste all copied rows (including header row) into new sheet,
4d. From inside Excel, open a pre-made MSWord template and merge the copied records (excluding header row), save and print,
4e. Close Word,
4f. Delete newly created sheet (Sheet3),
4g. If possible, change all the 'Yes's on the original sheet (Sheet2) to 'No' so they won't be 'picked up' then next time the macro is run.
4h. Unfilter Sheet2 to show it's original order.

This is one of the last things I need for my project which I need to try and finish this week, so anyone's help would be fantastic. Thanks!

Hello? Anyone home?