Consolidate data from multiple worksheets (based on condition)

Hi All,

I am having some trouble trying to figure out the best way to copy and paste rows of data onto a summary sheet based on the condition of a drop down menu I have. I have multiple workheets of customer data (For ease, I will refer to them as Sheet A, Sheet B, Sheet C etc) containing information such as Company name contact name, comments and follow up (Y/N), and I want to copy the data contained in each sheet into a summary page (which I've named "SUMMARY") assuming the condition of a drop down menu in column O is set to "Yes". I have static data in the first 20 lines of each sheet which I do not want to touch, but to copy everything else.

I have to admit that I have not had any formal training in VBA and have tried to get by on my limited knowledge, but have run into difficulty. Put simply, I want to copy an entire row of data from every sheet in my workbook assuming I have selected "Yes" to follow up, and paste all of the rows into one sheet. I would then like to ultimately sort by date. Please let me know if you need any more info.

Thanks in advance

Maybe:

Please Login or Register  to view this content.