I have a workbook with 30 sheets, one for each person. I individullay add
data to each sheet each week.

I would like a front sheet that accumulates parts of this data in a tabular
format - sort of like a pivot table in reverse. So as i add data to Sheet 1
it appears on the front sheet, then Sheet 2 would appear underneath.

Any ideas??