Cleaning Data Automatically in Excel

Hello, I am working on a project in excel and I need help to automate a few steps. I am trying to build something in excel that will automatically copy different cells in one sheet and paste it in an...