Hi,

I have a workbook where Sheet 2's info is generated from data entered into Sheet 1. I need more of these sheet pairs in the workbook but when I copy them, the formulas in the copied Sheet 2 (now Sheet 4) are still pulled from Sheet 1, when I would like them to be pulled out of Sheet 3. Is there a way around this?