Automate Weekly Copy/Paste of Hierarchy

Kishan Naik RA

I have a weekly tracking sheet that I update each week by doing the following: 1) Copy/Paste the current week's hierarchy (lines 546-561 in screenshot) to the last row of the sheet, 2) Update the week column, and 3) Clear some of the data for the new week. While this doesn't take a long time for one sheet, I do a similar process for other weekly trackers and am curious if there is a way to automate some or all of the steps in my above process. Any help is appreciated!

Kishan Naik RA

For some reason I am unable to attach my screenshot right now, I will try and do that when allowed