Formula for coping cell content AND format

Hello,
I am looking for a formula that would copy cell content and format (font color) from one excel sheet into another cell in another excel sheet.

For example:

Cell A4 in "sheet 1" contains the phrase "Class Room 1" and the color of the phrase is red. I want the same phrase and its color to be copied into cell A4 in "sheet 2".

It is also important to me to that if I ever change the color or the phrase in A4-Sheet 1, the same changes (in color and/or phrase) will take place in A4-Sheet 2. So, if I changed the phrase into "Class Room 2" and the color is blue, the phrase and color in sheet 2 will change automatically.

I hope this makes sense.

Thank you!

Well, I think you can copy the content of a cell into another with a formula. For example, =Sheet 1!A4! Will copy the content of cell A4 in sheet
1 into another cell.

Does this make sense? I want the same, but not only the content, but also the color of the font.

Thank you. This makes sense.