I have a project I am working on that involes inventory in and out. I have a logsheet which is sheet1 this subtracts from inventory. Then I have a delivery sheet2 that adds to inventory. My third sheet is inventory that tracks both with totals. I have 5 items that I receive and track. Is there a way to write a formula that when you add info to sheet 1 or 2 that is adds a line to sheet 3 and copies the formula to that line from the prior line?