Hi,

I have a spreadsheet that I use to summarize various long inventory lists. I'm using various functions which reference another worksheet in the workbook. Everytime I copy this worksheet and link it to another inventory I have to change each function to link to the new worksheet. Is there anyway to link all these functions to one cell and insert that value into every instance of that function.

Ex.

Inventory sheet "10-1479" is linked to worksheet "10-1479 Summary". A function on the summary sheet looks something like :
=SUMPRODUCT(('10-1479'!$B$3:$B$60060=1)*ISBLANK('10-1479'!$I$3:$I$60060)*('10-1479'!$L$3:$L$60060=TRUE))
Is it possible so that when I copy this summary sheet and link it to inventory sheet "10-1488" that I can insert a reference to a cell in all my functions to save me all the time of altering each one so it looks something like
=SUMPRODUCT((A1!$B$3:$B$60060=1)*ISBLANK(A1!$I$3:$I$60060)*(A1!$L$3:$L$60060=TRUE)) and I could enter 10-1488 into A1? Any suggestions are appreciated.

Best Regards,
Mjack