You'll get plenty of suggestions that you have taken a slightly wrong structural approach to the problem.
This isn't really a copying-fields problem.
The preferred method is to have a contacts table where you enter the contact information; and to link other tables such as your pending sales table to the contacts table.
The pending sales table in its most basic form would have the customer ID; and sales product ID and date the pending sale was initiated; and perhaps some other data strictly about the pending sale (price for instance).
No product or customer information needs to be present in your pending sales table.