I'm relatively new to vba and require some help constructing a code .

objective: i have a huge set of data 200k+ rows which is updated monthly, each time a new report is ran there is a template sheet where i drop the data and have to manually update three pivot tables linked to it that then do a find remove on one column to get rid of a set list of text. The second stage is to update and refresh the individual pivot tables and then copy this data into a summary.

All I want to do is to be able to put all that into a code so each month i don't have to do the repetitive task of manually removing the same text and refreshing the table etc

Anyone know how?