If you have, say, 100 worksheets, each having a 75x75 cell data array of numbers, each array being in the same location of each worksheet, how would one transfer a given cell location from each worksheet sequentially down a single column in a 101st worksheet. Each worksheet is a single data set, and I’m trying to track the progress of a given cell throughout the 100 worksheets by plotting its contents versus a known interval between worksheets. I’ll want to do this for several cells for several sets of worksheets. Seems like it should be a straightforward Excel maneuver, but I just can’t get it. Also, is there an easy way to first get the 100 separate worksheets into a single workbook, and then proceed with the 100 worksheets as described above?