Method for tracking corrections for a dataset that is reset weekly

Question

Each week I manually pull a very large dataset. In the dataset there two columns A - “Name” , and B - “Description”. Sometimes column A is blank, so I go with the first word in column B. I have created a third column C - “Correction” with a formula that accomplishes this. Since this does not always provide the correct name, I have to manually correct many of the entries.

Each week, I have to manually pull the entire data set again. There is no way to only pull new entries, and there is no guarantee that the order of the entries is the same, as sometimes new entries slot in the middle of the set. So each time, I loose all of the manual corrections that I make.

Is there a method to keep track of and automatically reapply these corrections? I have a vague plan for a rat’s nest of IFs and VLookups using the previous week’s data but I wonder if there is a better way.

Appreciate any help you could lend!