For this post, I am going to start from the beginning to give an overview of what I am trying to accomplish. I work for a company where I have built a PO calculator that operates from automatic price updating. There is an excel file for the Pricebook (automatically updated and exported from another program), which goes to another file that is a Part # builder, then to the PO Calculator (Pricebook.xlsx -> Part#Builder.xlsx -> POCalculator.xlsx). This is the flow of formula references in excel (lots of vlookup).