copy specific cells if it contains certain text to another worksheet (VBA) for each row in excel

[mhonse]

I am in need of some help, i have inherited a mess of an .xlsm and I need some VBA to remove all the manual information transfers.
Background info..
My data starts row 5 goes to row 300. with headers and macro buttons taking up 1 - 4.
Columns A-H are static'ish but for this VBA only A,B,C are needed.
I3:CN3 are headers in Date format, and need to be criteria for the VBA.
Now for the utterly baffeling part.. and i hope i can convay this.. (see screen shot ex 1)
When a user puts data in ( for example I5,K6,P7) That data and the corisponding information need to be copied to the Summery 2018 sheet(in this example)

The Summery 18 sheet will contain all the entries for each month in the 2018 portion of data (see Screenshootex2)

This needs to be repeated for summeries for all the years...

Oh and yes years are added and removed and sometimes removed. We currently have 7 years in but only go back to 2018.. so hardcoding by coluem does not work exaxctly..

I have looked at a lot of code that others have used for a starting point (most from this wonderful site..) but dont have the knowledge of vba to modify it to do anything similar to what i need. Though as I have spend a few hours messing with.. Copying a range containing cells that meet a criteria & pasting into a different sheet
But I dont have anything close to working

If anyone can help, or point me to some code snipets or samples that could help I would be very happy !

If more info or examples are needed I will do all I can to supply what I can..

Thank you in advance

 

[OaklandJim]

Without access to the workbook it is unlikely that you'll get assistance. Consider that someone willing to help has to guess about what is in your workbook and what is needed. Might you post a link -- using the link icon above the message box -- to the file using Box, Dropbox, 1Drive, Sharepoint, Google Drive?

 

[OaklandJim]

If not posting a file consider showing the data using Mr Excel's excellent add-in that enables posting of portions of worksheets. See HERE about the XL2BB add-in.