Is It Possible to Update Cells of Multiple Files?

I am not sure what you mean by "instead of the header", but following will update/set a cell value:-

Range("A1") = "my value"

hth
Ajay