Copying data from several sheets to a front sheet

[Marie Green]

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??

 

[Pecoflyer]

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??

Hi,

Ron de Bruin has different approaches to solve this problem 'Ron's
Excel Tips' (http://www.rondebruin.nl/tips.htm)


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faster