I am try to update our inventory workbook to make it more user friendly. I am having a problem with my master list. I would like it to update it's information off of the individual worksheets. I can not figure out how to do that except to do a cell reference and that does not always work. I am attaching a smaller version of what I am working on.

Abbyordertest.xlsx