I have a group of formatted cells and I want that each time a new sheet is created this group of cells to be pasted, the the user can fill the "table" with values.
gPHmJN6.png

I tried this way:

HTML Code: 
But it doesn't work. However, even if this worked there is a issue: What happens if the user deletes the Sheet1? Where will I copy the range from?
Is there some way to somehow store this range of cells internally to VBA or use a reference object to the Sheet1, not the actual name of the sheet.
Because the user may change the name of Sheet1 and my script will be invalid again.