=SUMIF(INDIRECT("'"&A1&"'!$G$2:$G$2986"),'Refund
Holds'!A8,INDIRECT("'"&A1&"'!$H$2:$H$2986"))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Harv" wrote in message
...
I have a function similar to this:
=-SUMIF('11-04-05'!$G$2:$G$2986,'Refund Holds'!A8,'11-04-05'!$H$2:$H$2986)

The '11-04-05' is the name of a worksheet. How can I write this so as to
be
able to put the name into a cell and have it automatically entered into
all
of my formulas like this.

I hope that explains it alright. If not, let me know and I will try to
explain it better.
Thanks