Spreadsheet Help with Formulas Across Several Columns with macros

I currently have a spreadsheet with data that is updated weekly.  there are two separate tabs that perform multiple formulas on that data and ultimately generate graphs.  currently once a week I copy...