Move rows from One sheet to another based on the year

I would like to thank everyone for all the great information on this site. For my first post I would like to ask for assistance in regards to moving a row of Data based on a year. I have tried to do it based on the information on this site but have not had any success.

Attached is a copy of the workbook with fake data. What I want to do is copy all rows from the worksheet DATA based on column G (Date) and copy it to a new sheet based on the date (all 2003 on the 2003 sheet and all 2004 on 2004 sheet.....). I have already created the new sheets including headers minus data. I would like to have all the data moved except the last to Columns AW & AX. I have two hidden sheets in this workbook. Would it be possible to have it auto-populate future entries from the "DATA" worksheet to autofill onto the new sheets?

I would like to thank you for your assistance.

Just noticed that I titled the Thread with Move but what I am asking for is copy. I cannot change the Thread title.