Copy Paste Macro based on Columns And Rows - Horizontal to Veritcal

I currently have a spreadsheet from which I'm using to organize my data. It's currently structured in the following format:

Column A
1
2
3

Column C-F is 'wrap text' and below it are the following headings A,B,C,D
Column G-H is 'wrap text' and below it are also the following headings A, B, C, D

What I'm trying to accomplish is the following:

copy all the fields in another spreadsheet Column A row one from C-F and G-H in another sheet in a vertical order if column C is year 2017.

This sounds confusing but I've attached a sample sheet. Currently, I'm doing this manually by row and it's taking a long time.

Sample attached

Let me know if anything else is required - fairly new to VBA

this is great - thank you so much Mr. MVP.

Quick question is there a way to insure we don't capture blanks or zero values? Seeing a lot of blank rows