Maximum & Minimum values - filtered columns across sheets

Hi,

This is my first post in this site (though I have read the forums for resolving my earlier doubts).

As a sample, I have attached an excel with the data.
I am trying to find maximum value of Profits in each year 2008, 2009 & 2010 (Columns B, C & D) for each unique item (Column A) from various sheets (Company-A & Company-B).
E.g., for Item number 165, the maximum profit in 2010 is 738 and minimum profit is -34477 and so on.
I would need the results in a separate sheet for each unique Item no.

So far, I have only been able to find an approach by filtering column A for each item value, then using subtotal formula to display the maximum/minimum values of columns B, C & D in cells and then copy using vba them to a new sheet.
I am not familiar with Pivot tables.
Can anyone please guide whether there is an alternative method which I am not aware of?
VBA code is most welcome.

Advance thanks

EDIT: Cross posted at Ozgrid & Mrexcel

Cross posted here: Ozgrid

and here: MrExcel

Resolved. Thanks a lot zbor & Mick for your quick replies. You guys & this forum rocks!!

zbor's solution meets my requirement perfectly! Though I am not familiar with Pivot tables, somehow I have worked this out.
I consolidated the data to a single sheet and used Pivot table to get the desired data.

Mick: Thank you for your solution too. Yet to understand the logic; will take quite some time for me to comprehend
Guess, I will have to go one step further from this and again compare min/max values of each item from each sheet to get the desired results.