Paste multiple formatted cell value to a few other worksheets at once-CodePudding

I have the cell, which has been formatted in various ways:

I have several font styling as well as various colors. Now, I would like to copy them and paste them across several worksheets in my workbook.

By far I "discovered" a good option for it, which is Paste as link picture.

The option seems to work well, but I still have to copy & paste it sheet by sheet.

I found some VBA code here:

select the cell / range to paste into and paste as required (normal, text-only etc)

make sure you select another sheet to "ungroup" them, or you could overwrite cells by mistake

Note - this only works if the pasted cells are in the same place on each sheet, so if all sheets need pasting to range L8:O8 then you're fine.