I am using a main worksheet in a workbook to capture information from other
worksheets within the workbook. I want to copy formulas without changing all
the formula. I only want to change 1 value when copying. Example:

='PO#6601'!F7

The only number I want to change when copying this formula is the "6601" I
want it to increase by one each time the formula is copied. I want
everything else to stay the same especially the "F7". This program is a
purchase order program with a ledger which saves all the information with
each new purchase order I record on a separtate worksheet.