Excel Report File

Hi, I wish to make a quick automated excel which will capture 14 different elements (5 percentage, 8 numbers and one text) for 20 people every week. Need a display report showing for all numaric elements for all 20 people (Last week, Last week - 1, Last week - 2, Last week -3, 8 weeks average, 12 weeks average), Same way in monthly/quarterly format also. Need automated individual report for all 20 people for individual elements.