Hi,
On one of my workbooks (Excel Windows XP Pro), I have information on
separate worksheets (sheet 1, sheet 2, sheet 3, etc). On my last sheet, I
would like to reference the same cell (ex. A1) on each of the previous
sheets. Rather than clicking on each sheet to reference (ie. =sheet1!a1,
=sheet2,!a1), is there a way to click and drag so the cell stays the same
(A1) but the sheets change?

Let me know.
Thanks!!