Copying certain rows of worksheet into new worksheet depending on date

[Alison1311]

I'm trying to copy the whole data from a masterwork sheet on to sub worksheets 2017, 2018. On the 2017 sheet I dont want it to copy rows that have a disposal date of 2017 in a column.