Automate excel steps for every week sheet

1. I get an excel file every monday for last week billing done which may include 1000 to 1500 rows depending upon sale, but all columns are fixed everytime.

2. Then we apply filters, remove some rows based on some filters.

3. copy theis data to new sheet, then apply pivot table for total sale.

4. then copy pivot table data to new sheet and then save

Is there any way to automate without learning excel programming.

I seen video using record macro, but after recording on one sheet when I tried on new sheet, it shows errors.