Dynamic Spreadsheet while Keeping Hidden Cells Hidden

Hi all,

I get work order spreadsheets and immediately filter them to include only the relevant rows and hide the columns I don't want to see. I am not able to simply copy and paste the new spreadsheet over the old because the two spreadsheets aren't the same size and I'm hiding the first column so I can't paste into A1. What I would like to do is set up a template, dynamic spreadsheet, or table that keeps the filters and hidden column even after I change the data. Any assistance would be greatly appreciated.

Regards