I want to create a summary page on one worksheet that references vertically
(in a column) the same cell from twelve other worksheets, either in the same
or different workbooks. I have several such columns, as well as several
summary pages. I have tried to use the autofill function, but it does not
appear to change the worksheet reference, only the cell reference. The twelve
worksheets represent monthly information. The summary page represents an
individual in the company. Select information from the monthly worksheet is
tracked for each individual to monitor their performance. I am using Office
Excel 2003, part of Office Small Business Edition 2003 .