macro to compile data over time

[wallywalls3rd]

I am collecting data for a project at work. so far I have a workbook for each person to collect data and a page for each day of the month in those workbooks. at the end of the month I am copy pasting it into a master copy for that month. and again for a master copy for the quarter/year. I will be using this information to track trends using pivot charts and tables. is there a macro that I can use that would pull all of the data to the next "master" sheet? kind of like a pyramid. so the employees would pull to the month, the month would pull to the quarter, and the quarter would pull to the year? I am newer to excel and have done all of this on my own. but I am not macro savvy in the slightest. but I have some coworkers that can help me implement it if I were to have the macro coding itself.