Extracting Specific Info from cells and making a new sheet/chart using VB

[AshWebster]

Hi all,

Here's the information I'm using in Excel 2010:

edit: the first upgrade2 should read upgrade 1

I need/want to look for the year (2015-2050), and extract the relevant information to each year on a separate sheet or chart, so that each year has all of its information in one place, or either a chart with the year along the x axis and org along the y axis. It need to be able to look through the cells for [2015] to [2050] and only extract the information up until the next [ including the [xxxx] before it. If its easier to do, the org (u or f) can just be colour coded, say u is red and f is blue, to help sort the information.

Is this enough information to help?
Also is it possible?

Cheers in advance,

Ash