How to insert data in multiple cells at once

Hello All,

I need guidance please, what I need is to insert the data in a cell, and instead of copying this same data to other cells in the same sheet or in other sheets, I need a way so that once I insert the data in one cell, it will be copied to the other cells at once.

For example, if I insert data in the cell [Sheet1,A1], it will be copied to [Sheet2,A4] and [Sheet3,E8] and [Sheet3,I7]

I think it is applicable but I am not sure how to do it.

Thanks a lot.