VBA remove all records from master sheet while auto refreshing and auto archival

[gunanidhi1]

Thanks P45cal but all the rows are hided automatically after clicking the save button. How can it be unhided.
Attaching the sheet once again. just click on the "save" button and see how all the rows hided.