automatic data update in master sheet from daily sheets

Dear All

Please can someone advise how I can get excel to populate the data on the master sheet from the individual daily sheets. I have attached sample excel.

In the sample sheet excel, on a daily basis I nned the data to be entered on the date sheets of the month, 1,2,3,4 etc and then wnat the master sheet to capture this information on the master sheet. If i went back to a day later on to add an extra entry, would the master sheet be updated also.

Thank you.

vba1234