Copying worksheets, to inherit named ranges from destination workbook?

Firstly I just wanted to say a big thanks to all contributors on this forum, I only come here when I need help and I'm always blown away by how keen and helpful folks are. I wish I could pay it forward by helping out other users, but you know what they say about bringing a knife to a gunfight...

Anyway, today's problem is about worksheets and named ranges.

I have several workbooks that are essentially the same, just with different data. They all use the same named ranges.

I need to add a new worksheet to all of them, which is a summary page for printing. I have created the first one and done lots of layout and formatting work, with custom headers and footers for printing. I'd like to just copy this worksheet into the other workbooks, along with all its formatting, but when I do it is unable to find the relative data in the destination workbook.

The problem is particularly annoying because according to the formulae, it IS looking for things in the right place. The issue is obviously the named ranges - where IT thinks "RANGE1" is, isn't where I think "RANGE1" is.

Is there a way to copy a worksheet and its formatting into a new workbook, and get it to use the named ranges in the recipient workbook rather than the donor?

The ranges are generally all of the columns in a given sheet, given a name like "STOCKDATA". Subsequent sheets find the data they need by using (eg) "=VLOOKUP(A1,STOCKDATA,2,FALSE)".

Does this answer your question?

I have no idea about scope, it isn't something I have set so I'm sure it would just be whatever the default behaviour is for Excel 2007. I just select all columns then give it a name in the name box, and that's my named range.