name and date in the same cell

in b1,d1,f1 and h1 I have a mane in the cell, is there a way that when I open the worksheet, sheet3, that the name stays in the cell and then todays date
will end up to the right of it in the same cell?

thanks
Keith

where do I put that formula?, i'm still new to excel, when I right click the sheet and pick view code then paste it there it all turns red

thanks
Keith