Can't delete data across multiple selected sheets

Good morning everyone! (It's always morning somewhere)

I'm really struggling to understand this, but leave a complicated sheet in someone's hands for a week and it's all to pot on my return (don't we all get this from time to time??!)


The issue i'm having is, I can select multiple worksheets, but when I delete a cell, it only deletes the cell on the active sheet, it won't delete it across the multiple sheets i've selected?

Never had this and google'ing it only really brings up 'how to' which I know how to, it's just not doing it.


Any help would be massively appreciated.
This neither works in macros or manually doing it.

Thanks all!