Hello, Thanks you for any help you can give- I will do my best to describe the problem. I am using a pre-made workbook- I emailed the company who provided it and they referred me here.

This workbook has an overview sheet then a number of note pages. It's made so that each column of the overview (first sheet of the workbook) corresponds to each one of the the note pages (next 10 sheets in the workbook). When I fill in text in an overview column, it automatically in puts that text in the corresponding note sheet. On the note sheets, the first three columns are locked - this is where the info is automatically entered. Then I can add additional notes beginning in the 4th column.

my issue is that I changed text on the overview page using the cut and paste function and instead of it automatically being changed to match on the corresponding note sheet. Some of the fields show #REF! instead of the new text I typed in the overview sheet. It is all out of whack now. Does anyone know how to fix it?

Thank so much!