I have a workbook I'm working on for inventory and I was wondering if there was a way to have info I put in cells on one sheet to automatically transfer to another sheet. So I have 3 inventory sheets and 12 sheets for each month. When I put the information on the inventory sheets I need it to automatically go to the month it was bought. But I also need it to go to the month it is sold when it is sold. Is this possible?

B.