how do i get a total for a list of names entered in

ie alan billy chris dave ......

also is it possible for the date to be automatically enterd in each sheet

tia

jkf