| On the first sheet, A1's cell color is filled manually|
Does it have to be colored manually?
If you could use Conditional Formatting to color the cell,
then you would only need to copy the Conditional Formatting.
The only other way I can think of is with some VBA code,
and my VBA skills are just above nil.