Sorry if this problem have been discuss before. I'm not sure what the right keyword to search for my problem..

every day i have to enter some data in each sheet. In each sheet I have data from 1st of each month until the end of the month. I do some calculation on this sheet.

Example in each sheet: (Three Sheet for three school)
School A - 10 data to be enter every day
School B - 10 data to be enter every day
School C - 10 data to be enter every day

In the other sheet I want to see one day data for all the school

What i done now i have to build 31 sheet with same table for one month if i want to see all the three school data in one sheet.(one day one sheet)

Hope someone can help me to use only one sheet to see all three school data for each day in the month. Hope that i can only change the date in that sheet to see the other data for other date.

BROKEN ENGLISH!! sorry.....