I have multiple sheets in a workbook. Each sheet is labeled per month of the year. However, I need to merge all entries in multiple sheets into one "annual" view. but I only need to copy all rows which have a status "Approved" or "Completed".

I have 7 columns. the last column is the status. I need to copy all columns of all sheets and append them into one sheet as long as column G is set to "approved" or "completed". Everytime the monthly sheets are updated, can the "annual" sheet be automatically updated or at least triggered by a button?

Is this a macro/programming needed or is there a simple formula that I can use?

Thanks.