VBA Code: Copying rows from multiple sheets

Hello,
I'm trying to use VBA to copy rows that satisfy a certain 'If-Then' statement from multiple sheets in Excel onto one sheet. All of the sheets have the same columns and each set is one month in a year. I've gotten the code to work for one sheet but I need the next month's rows to be copied on to the final sheet relative to where the previous month's ended. The first month I've copied is 'April' and I am copying all of them onto a sheet titled 'Change Summary 1'. Here is my code thus far:

Please Login or Register  to view this content.

My biggest problem is making the next month show up relative to the month before it on the 'Change Summary 1' sheet. Any suggestions are appreciated, although please note that I am VERY new to VBA and don't quite fully understand it yet. Thank you in advance!

Can you upload a mockup workbook of what your wanting to do?

One question. Is the Summary Sheet to be cleared everytime before running the macro?

Give this a shot

Please Login or Register  to view this content.

This is what the AUTOFILTER was created for. It lets you apply a filter to a set of data to see just the rows that match a certain criteria. In this macro, we're applying the AutoFilter to column I for the word "Yes" then copying all the visible rows to the summary all at once.

1) Right-click the Summary tab and select VIEW CODE
2) Paste in this event macro:

Please Login or Register  to view this content.

3) Close the VBeditor
4) Now click on any Month sheet, then click back the Summary. The "activation" macro given will trigger itself and recreate the Summary page new each time you do that.

Or if you dont want the dropdowns added to the Summary sheet use this

Please Login or Register  to view this content.

The AutoFilter worked, however it did give me an error message after it worked saying "AutoFilter method of Range class failed". For whatever reason, the macro begins placing the data a column too far to the left, starting with column 'F'