I need to create a spreadsheet that takes the data in cell K10 and places it
in the right section of the header.

If this is a macro solution I am not highly skilled in them so as much info
as possible is appreciated.

Thanks in advance.
Michelle