I have a workbook with a variety on of worksheets. I've created a worksheet
that gets information from each of the worksheets and displays it on the same
worksheet. I use the following formula in one of my cells:

='June 3'!$B$4

I can get the information that I need. Now, that I have this worksheet set
up, I would like to use it in other workbooks, but they have different names
on each of their worksheets. Is there a way to write the formula so it knows
to take the information from the current worksheets in the workbook in which
the formula page has been pasted??? Right now, I've been re-typing the
formula page in each workbook and it is very laborious....The cell reference
will always be the same. It is only the name of the worksheets that change
in the different workbooks....

Thanks for any help that can be provided!!