Reference a cell within a row and then populate with the value that is last in the column

Hi all,

I am having a problem with a spreadsheet I am working on. I have a table that contains a bunch of heading and then some values under those headings for each month. Another table then populates with the 12 most recent values from this table, and a chart runs from that table to give a graph that only display data from the last 12 months.

The problem is that currently the values in my 2nd table are only displaying the first 12. The way I would want it work is to read the heading of the 2nd table (currently in BW5), find that value in row 3:3 to find the correct column, and then return the last value in that column. From there I can work out the rest to populate the other 11 rows. The range to search in is B7:BJ100.

I'm sure the answer is right in front of my eyes but I just can't seem to get it to work.

Thanks for the anticipated help