Adding cells from multiple worksheets

Read
New Posts
Reply To
This Thread E-mail It

Print It Next
Thread

mistos (IS/IT--Manageme)
Mar 8, 2002I have multiple worksheets that are all identical except for data and the
worksheet name. I also have a worksheet called Tally. I am looking to
take the same cell from every worksheet and copy the data in that cell
to the corresponding row in the Tally sheet. The Tally sheet consists of
the names of each worksheet. Currently I am going to each row in the
tally sheet and typing ='sheet1'!F1 for each row item in the tally sheet
corresponding to the named worksheet. Is there any way I can do the first item in the tally and then drag down the the cell, having it take cell F1 from each worksheet and corresponding its similarly named row in the tally. The rows in the tally sheet are in the same order as the worksheets.