I want to create a macro in a master sheet that will copy last weeks data and paste in the rows below. Then I want it to open a sheet that the data is in and replace the date so the new rows pasted is referencing this weeks data (it would be last weeks before this since I copied over last weeks data rows). Does that make sense. Basically, each week I get new data that I link the master sheet to, and have been manually updating this. How can I create a macro to update on its own?