I 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.