I have made a grocery price book with 4 sheets in the book
sheet1-price entry log
sheet2-lowest price
sheet3-info sheet (store names, category, sub categories)
sheet4- grocery receipts

what i am having problems with is that I am wanting to find each product name in sheet 1 along with the lowest price i had bought it for and putting it into sheet 2. if i enter a product name that is already listed in sheet 1 but has a lower price, i want sheet 2 to automaticly update that product name's lowest price.Would like for sheet 2 to be able to do this on auto. I want the date and store to change with the price if it is different from before.
example:
date, store, category, product name, price, weight, unit price
6/6/2012, kroger, bread, wonder sliced white, 1.99, 1lb, 1.99
6/7/2012, target, bread, wonder sliced white, .99, 1lb , 2.99


want the info in red here to automaticly go to sheet 2. (won't be colored in my sheets)

I really hope i am making since here.