Advanced Find and Replace VBA Help

Hello All- be gentile please!

I have a find and replace situation that I’m attempting to resolve but have been unsuccessful.

Sheet “Last Week” Contains last week’s data
Sheet “This Week” contains some updated information that I want to replace, but only if there is updated information.
Sheet “Update” to contain the “This Week” updated data, but I need to preserve the comments related to the specific widget(product number)

Workbook attached