Hello from Steved

Question please.

I work in Column A:A off a worksheet and have up to 5 files opened

In col A I type for example 1234 in a cell say A5

I need to type in the same value several times in the 5 different Files.
Is it possible please for a macro to copy the value from cell A5 and paste it
in Column A:A on any opened worksheet as at the moment I am typing the same
value in time after time. ie it could be cell anywhere between A1 to A500

Thankyou in advance.