One way

Try in any starting cell:

=INDIRECT("'health care'!C"&ROWS($A$1:A1)*5-5+9)

(above returns ='healthcare'!c9)

Copying down will return in successive cells:

='healthcare'!c14
='helatchare'!c19
='healthcare'!c24

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
cindi wrote in message
...
I have external sheet references in a worksheet and I
want to copy the formula's, but can't figure out how to
do it. Can you help?

Column A
='healthcare'!c9
='healthcare'!c14
='helatchare'!c19
='healthcare'!c24

and so on....

What function of Excel can I use to copy the formula down
and skipping every 5 cell references? Is it possible? I
have tried to "Fill" it, but with no success.