This is helpful but I still have a glitch somewhere. In my dependant
worksheet (sheet 1), It will pull the information in cell A7 from sheet 18
cell a17. The fill handle will then only pull 2 more pieces of information -
in cell A8 it pulls from sheet 19 cell A17 and in cell A9 it pulls from sheet
20 cell A17. This is the right idea, however in cell A7 I need to pull from
sheet 2 cell A17; in cell A8 I need to pull from sheet 3 cell A17; in cell A9
I need to pull from sheet 4 cell A17 and so on. I want to be able to use the
fill handle so that it just changes to the next sheet but still pulls data
from A17. Starting with sheet 2, my sheet name is CO_1; sheet 3 is named
CO_2 and so on.

"Ron de Bruin" wrote:

You can use the indirect function
This will use the row number where the function is

copy this in C1 for example to display the value of Sheet1!A1
=INDIRECT("Sheet"&ROW()&"!A1")

You can copy down for Sheet2.........Sheet?

--
Regards Ron de Bruin
http://www.rondebruin.nl



"cjgeorge" wrote in message ...
I have a workbook set up where my worksheets are linked. When I use a fill
handle one my dependant worksheet, it will not change the number by one. The
number in represents the name of the independant worksheets. Will the fill
handle not work in this case because the number is actually a name for the
worksheet itself?