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?