Macro or help with populating data after inputting

I would like to be able to enter information into the sheet shown daily (therefore every day different and new data will be inputted into this main sheet for each of the data columns). I would then like this data to transfer over to another sheet (one sheet for each name shown). I want the data to populate for each day and then create a weekly average, monthly average, quarterly, and so on. I am having a lot of trouble understanding how this can be done and keep populating over and over again after new data is inputted. Help on this would be very much appreciated. Thanks!