Hello: I have read some ways to make this work but when I try them it doesn't. I want the macro below to be part of my file, then weekly I have to save the data into a new file and the tab where this data is located gets a new name. So I would like the macro to work on the active sheet, but it...