.. The original formula I used was ='PO#6600'!f7 and it worked fine.

.. Basically I want the opposite. The F7 to stay the same

and the PO# to change by increments of 1.

Yes, think I got your intent correctly earlier. The suggested formulas

should have worked*. They work ok here when I tested them prior to posting

the response.

*except for a minor adjustment in the number "6600" (I had a mistake there,

it should have been "6599")

Assuming the formulas are to be copied down

Try it again, adjusted like this, in B2:

=INDIRECT("'PO#"&ROW(A1)+6599&"'!F7")

Copy B2 down

(To avoid typos in reproducing the formula over there,

try a direct copy of the above formula from this post,

then paste it into the formula bar for B2)

In B2, the above would return the same as your link formula:

='PO#6600'!F7

And when B2 is copied down to B3, the formula will increment** to return the

same as the link formula: ='PO#6601'!F7, and so on, giving you exactly what

you want.

**the incrementing is via this part in the formula: ROW(A1)+6599

Note: If you're copying across instead of down, use in B2:

=INDIRECT("'PO#"&COLUMN(A1)+6599&"'!F7")

If you get #REF errors, this probably means that there's some inconsistency

between the actual sheetnames and the sheetnames stringed together within the

INDIRECT. Both must match exactly (except for case). Recheck the actual

sheetnames that you have. Watch out for any trailing whitespaces in the

actual sheetnames. These are hard to see and will throw the matching off.

Of course, any new sheetnames that don't exist as yet will return #REF

Try it again, let me know here how it went for you.

---