print the name of and individal in B4 and it would automatic put it B12 is this possible

wjallen14 

But I must ask "Why?"

Is this a matter of printing, such that the name appears at the top left corner of each page? there's another way to do that.

Under File....Page Setup....Columns to repeat at left

I only want to make the point that usually one would avoid repetition of a cell--it's kind of inefficient--so it makes me wonder what your purpose is.