Macro to calculate Month to year sales based on month selection

Dear friends,

I am struck in finding solution to write macro to calculate the sales year to month based on month selection. I have attached the data for reference.

I would like to have the data as following

1. First I have year drop down where I will select the year ( Apr-Mar series) Ex 2015-16
2. Second I have month drop down I will select the month Ex Jun-16
3. Third I have year to date column where i want the sales from Apr-16 to Jun-16 based on my selection of Jun-16

Regards,
Chandu