I have a excel workbook which contains 3 worksheets (a, b and c).

I would like to make life easy whereby "whenever a change" is made on the
source worksheets "a" and/or "b", it will automatically be reflected on
destination worksheet "c" on the designated cell locations.

The content of the "source worksheets/cells" (including cell format
definition; bold, font, border, highlight, etc) should be reflected on "c"
destination worksheet./cells.

Thank you.