I have a worksheet that basically pulls pertinent information from two separate workbooks and compiles it into one. Obviously, the majority of this sheet is reference formulas, except column P. There are times that I want to override what the formulas pull in with more accurate information. Right now, when I do this, the cells that I override are static. So if I add information to one of the "database workbooks" and the rows shift, that override value does not shift with its original row. This is problematic because my overridden value is now in a row of data it doesn't belong to, and the row of information it was meant to be with is reading the formula again.

I've never had this problem before. Is there a way to fix this? To make each row retain it's data, even if more data is entered and the row numbers are later reassigned?

Thanks in advance for the help!