Populate data

[donkey_uk]

I have a training sheet and I would like to populate the data onto another sheet based on the dates.

So on the matrix sheet I have lots of different training courses along the top, down the side I have names and start dates for training and end dates for training.

I want to populated all the end dates ( highlighted in yellow) for the whole year ie 1/04/2016>30/3/2017 into the training plan sheet.

so on the training plan sheet the total of training *that is due in a April will show on the plan (P) and so on for each month.

I would like it so it reference the date " Matrix tab cell BY1" this way i can just put next years dates in and do the same

[donkey_uk]

If you need more details please let me know