For demo purposes, I'll assume the following:
1)Sales are entered on the Historic Sales sheet in chronological order.
2)Products are listed in col O on that sheet

Enter a product in cell A1 on Sheet 1.

Enter this formula in cell B1:
=INDEX('Historic Sales'!$P$1:$P$1000,MAX(IF('Historic
Sales'!$O$1:$O$1000=A2,ROW('Historic Sales'!$O$1:$O$1000))),1)

Commit that array formula by pressing [Ctrl]+[Shifr]+[Enter]

ALSO: If you have more that 1000 rows of sales data, change the 1000 to
whatever is appropriate.

If that works, copy the formula into subsequent cells.

I hope that helps.

Regards,
Ron