Need help with functionality more complex than VLOOKUP offers

First, I've attached an example of the three pages that I am trying to get working.

The first page is the data, sorted by year then by product. This data is always in ascending yearly order. Page 2 and 3 are displays and graphs of each individual product.

I want to setup Excel to automatically fill the tables on page 2 and 3 based on what data is in the columns in page 1. VLOOKUP has some of the functionality to accomplish this. So, for example, the function would look up the product and bring back all associated rows and columns.

Is there any combination of functions that can perform this type of behavior?
Thanks!

The answer is using Pivot Table,

Have a look at the enclosed file there is no macro just the use of pivot table.
Francoise