Excel Data Transfer & Cleanup

I have one Excel workbook that needs to be migrated into a new, cleaner file. The source is another Excel spreadsheet; no PDFs or web scraping are involved. What I need from you is a smart transfer rather...