Please help.

I have a table on the "Monthly Volume Review" tab. I'd like for the months listed there to stay static. However, I'd like the "current" and "Previous Year" columns to change based on what month selected in cell E2 on the "Volume Data" tab. The data should represent the "Total Color" row (row 196) on the "Volume Data" tab.

For example, if I select "Aug-14" in cell E2 of the "Volume Data" tab, the "Current" column for Sep should read 827,986. Then Jul would read last month's total of 899,365 and so on.

The same goes for the "Previous Year" column on the "Monthly Volume Review" tab. Except the numbers there would obviously represent that same month, but for the previouse year.

I guess the tricky part is to get the table to display ONLY the data for the 11-12 months at a time, based on the month selected in cell E2 on the "Volume Data" tab.

Any help would be greatly appreciated! Please see attached

Book3.xlsx