Honestly, most shops use an ERP software to do this. I really think that you should look into some less expensive ERP systems because the amount of time you would save would more than pay for itself in a short period of time. I know one system that is very affordable is made by Xtuple. That is just my opinion. Having a software that can track all of this for you will be much more efficient and accurate than multiple excel spreadsheets doing individual tasks. Good luck!