Capturing & Keeping Data

Need help capturing data from continually updated spreadsheet.

Specifically, sales $'s are tracked by customer until payment in made, then deleted. I want to capture that sales elsewhere to keep a running tab on total sales.