Update data in one sheet with NEW data from another

[lmp884]

In the workbook at the link below, I have "box referenced" (on each sheet) where I am not able to find an solution to the issue of updating the existing sheet with new data feed from my supplier into the active running sheet.

Please look at the sheet to the very right first then it addresses the sheet next to it on the left. ... then it gets a bit more complicated with the sheets even further to the left from a different supplier.

Any help, I can't find in any of the threads ... many come very close, but I can't get the result I'm looking for by trying to modify the function meant for a different task.

Please and thank you!

Current Workbook


My current version of Excel is 2007 if that makes any difference.

[lmp884]

Tried to delete follow up post