Fresh insight to an excel problem

I hoping to get some fresh thoughts on a problem I'm trying to solve in excel.   I work in a manufacturing plant and my job is to track the location of certain product as they move through various ...