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?