Have you ever used the MATCH, ISERROR, ADDRESS and INDIRECT functions?

If need be, you can setup a particular cell as the cell to contain the name
of the worksheet, which would then allow you to change it in just one place
rather than in multiple places. There are of course cautions to take place,
but I presume you know enough about some of the precautions like when you
get to changing things in various places, you can accidentally overlook some
location.

The formula can look something like:

=IF(ISERROR(MATCH(C134,INDIRECT(T1&"!A:A"),0)),"", INDIRECT(ADDRESS(MATCH(C134,INDIRECT(T1&"!A:A"),0) ,2,,,T1)))

Where T1 contains the name of the worksheet that you have added to the
workbook.

--
Thanks,

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
"bcw_now" wrote in message
...
Example, I want to add a new monthly data worksheet to by workbook and
pull
all the present and past monthly data for a specific client. Currently
the
data is pulled through multiple vlookup functions and everytime I add a
new
sheet, I continuously need to manually change the functions worksheet
reference. Is it possible to assign a cell with the new worksheet name
and
link that assigned cell to that function without manually changing each
vlookup function?