Creating a Macro to copy rows with certain criteria from multiple sheets in to a new sheet

[bailsmb]

I'm sorry about the complicated title.

I've reviewed the site and I've seen a couple threads with Macros, but I've never worked with macros so it's over my head.

What I'm trying to do is copy rows from any of the sheets where the status is neither "Resolved" or "NA" onto our main Exception tracking sheet.

For example:
Sheet = Third Party
A B C D
1 Bob TEXT TEXT
2 Dave TEXT Resolved
3 JANE TEXT NA TEXT

Sheet= Operations
A B C D
1 SUE TEXT Resolved TEXT
2 GREG TEXT
3 TINA TEXT TEXT


My sheet entitled Exceptions would show:
A B C D
1 Bob TEXT TEXT
2 GREG TEXT
3 TINA TEXT TEXT


How could I create a macro to accomplish above, and leave the data in it's original location.

Lastly, on the "Exception" sheet, would I be able to put an "Update" button to re-run above as it is being worked?

Thank you for your assistance.

 

[bailsmb]

bailsmb,

Thanks for the latest workbook.

I am not able to understand what I am seeing in your latest workbook/worksheets.

They do not resemble in any fashion what you posted in your original reply #1, and, reply #2.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

Instead of Column "C" in original example, it is column "H" in live worksheet.

 

[hiker95]

bailsmb,

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[bailsmb]

Bump