copying a sheet in a file

Go to Formula > Name Manager and take a look at the names that are set.

Also check if there are any named ranges referencing Tables as this can give rise to this issue.