I have a workbook with multiple sheets. One sheet is a summary sheet pulling
info from the other sheets. Is there a way to autofill a column with a
formula and have Excel increase the sheet name but keep the cell reference
constant? For example, I have the formula "=LOOKUP('Sheet (2)'!$G$1,'Sheet
(2)'!$G$1)" Down the column I want Excel to simply change the reference
sheet name to Sheet (3), Sheet (4), etc without changing the reference to
cell G1 so that I'm pulling the info from the same cell in each sheet. Any
thoughts? Thanks in advance!!!