Copy work*** excluding defined name ranges

Hi,

I am really struggling with this and would appreciate some assistance.

What I am trying to do is to copy a work*** from one workbook to
another. The thing is that both workbooks contain defined names and I
do not want the defined names to follow the *** when it is copied to
the other workbook. Is there any macro that would either exclude the
defined names in the process of copying the *** or delete all local
names after the *** has been copied? Both alternatives would work
for me.

Really hoping to get some help on this!
.