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