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