Copying a layout and the formula for names to a new worksheet

[JohnSmi]

For part of a lab I am working on, I need to import a lot of data files into excel (easy), and then choose appropriate places in the data to determine the baseline, slope... The way that I did this was to use Names to let me use dynamic graphs that change as I choose different start and end points. However, when I make a new worksheet, it appears I need to retype all the formulas in again, and change the graphs to use different names.
This is unlike how it normally is if I copied the formulas from one worksheet to another: If I had =A1+A2 in one cell, I could paste it into a new worksheet and have it do the same calculation on the new data.

I tried making sure that the names were scoped to just the worksheet that they came from, but that doesn't seem to help either.

I am probably missing something simple, or am missing a simpler way of doing what I wanted, can anyone help?


Ignore Pulsed and Modulated in the uploaded file, PdP1 is where the formulas/names/layout was created, which were copied into PdP2 (that has different data in A and B).