I hope I can exlpain this. I have two sheets, the formula I am using in sheet 2 is =A1+'Sheet 1'!A1. This gives me the correct formula but when I copy a third worksheet I need the formula to be between worksheet 2 and 3 instead of 1 and 2. Is there a way to write a formula that adds the previous worksheet info instead of always going back to sheet 1. Please help...thank you!!!