If you create the named ranges using name manager in Sheet1 and set scope to 'Worksheet', then you copy the sheet to another (right click tab and then the ranges in the new sheet will be local to that sheet only, as shown in the previous diagram (prefixed with the sheet name). The default when creating a name in the Excel box (top lhs) is 'Worksheet' so best to create using name manager. Gook luck:)