Take a step further!

You need a sheet, where you enter all sales information for all items.

And you need a report sheet, where you select an item, and all needed info about this item is read from first sheet (really you can have any number of different report sheets with different kind of reports).