Is there any way to insert a formula into Excel that will automatically purge
or transfer data into another spreadsheet? It would be so much more time
efficient.

Thanks for any help!