Copy/paste named range and redefine references to new workbook

[mhoude]

Hi,

This is my first post in a forum. I'm self-learning vba coding and have a problem with named ranges.

I actually have 2 workbooks. First contain macros and templates and second contains datas. When i'm done compiling datas, i copy summary template in wb1 and paste it in wb2. I rename it and there come the problem.

Summary contain around 100 named ranges which still refer to wb1. I want them to refer to wb2, and to new summary tab name. I can i redefine them with vba?

Thanks for help

[mhoude]

Here's more infos

I have a macro file with a jig for my sales per departement and a jig for profits per departements with A LOT of named ranges.
In another file, i have all sales listed.

When i run the macro, i want to create a sheet per departement and a sheet for profit per departement. So i need the named range to be local (no name conflicts) but available for the other sheet (need sales total per departement).

This is the context.

The problem is i dont know how to redefine reference of named range and eventually scope.

Thanks for help