What function of Excel can I use to copy the formula down
and skipping every 5 cell references? Is it possible?

One way ; do the first two manually (='healthcare'!c9, ='healthcare'!c14),
then do a Replace (CTRL+H) of "=" with "x=". Then select *both* and drag
down (click & drag the small black square ("fill handle") at bottom right
corner of selection).

When you're down as you need, do Replace again but this time replace "x="
with "=".

Rgds,
Andy