Excel Macro

I'd like you to take a CSV file with data and create a Macro that removes columns, create 6 new ones, with simple formulas, adds filters and creates an output based on that.

I'd like to be able to paste the CSV data in to the new sheet, run the Macro and see the output.

Thank you.