Searching for month, returning data from different cell

I have attached a sample of what I'm trying to do. I need to get B3 to autosearch C2-C11 and return the data from the cell right below it.

The month columns are fed from a different worksheet in the same workbook. Need each cell under Current Month to show the data in the cell on the same row under the current month. Also, when the month changes I need the data to automatically pull from the next month.

I hope I have explained what I need well enough.

Thanks.