Ok, so I have a workbook, each sheet is an order form, I want to reference
the same cell on each sheet on a Master Tab that takes the info from each
individual sheet and copies it to the master tab. I have referenced the cell
on the first sheet (1) with an absolute cell reference (ie: ='1'!$C$1) and I
have about 50 columns of this data. I would like to fill down and have the
'1' from the formula change to 2, 3, 4, 5, etc. You would think there would
be an easy way to do this. Anyone know how? I have been working on it for a
while with no luck. At this point, it would probably have been faster to
just manually change it.

Ideas?

Jen