s a way to move the information each sheet
Did you mean "Move" or did you mean "Copy?"

Why have the intermediate step of Vendor Sheets? Why not just work with the "Purchase List" sheet?