populate a chart counting numbers input

[jafooli]

hi, ive been looking and thinking for 2 days now and cant see to work out how to do this... what I would like is say if i put 75 in F6 it will copy to another file in D6 and then i can add totals up. but how can I set it up that if insted of putting 75 in F6 i put 50 or 25 how can i get it to put it into another cell C6 into the other file? also how can I get it that it knows what kind of sheet I am using and what date?

attached two files which i working on

all help gratefully recieved