Hello,

you code contains a For/Next loop that runs on each sheet in the array. In each iteration, it copies the sheet FOOD CHANNEL-FORM and then renames it with the content of cell I3, which is probably always the same content, hence producing the same sheet name. And that is not allowed.

The code could be tidied up. Apart from not using the For/Next loop, there's a lot of selecting and activating that is not required.