Lock formatting but allow copy/cut/paste between tabs

[ClaireLou]

Hi

I have a sheet that records our sales. There are 5 different tabs on it (new sales, renewed, awaiting dates, booked, completed).

We have a further tab in the workbook that updates customer reference numbers directly from our database using an INDEX MATCH. To make this work, I need certain columns on each tab to retain certain formatting.

Is there a way to lock the formatting so it can't be change but allow copy/cut/paste between the tabs within the worksheet?

Thanks