When I run my macro, a new sheet is created with a template that pulls from a data sheet. I have a certain range that I have copied and pasted (via VBA) and if I add a row in the data sheet, the macro-created template doesn't update itself (because it is copied and pasted). Alt+Ctrl+F9 doesn't do the job of refreshing the data so that the new row shows up. Is there a way to update the macro-created template while still being able to use the copy/paste method?