Thanks...

That does work but it also has a lot of steps to it. What I'm looking for
is a bit more, I guess, automated and easily like a click of a button,
choosing which sheet and then the cells are updated. Do you know if this can
be done?

"Arvi Laanemets" wrote:

Hi


ReplaceAll (OldSheetName NewSheetName)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"MikeyS" wrote in message
...
Hi...

My question has probably been answered somewhere in the community; but
either I cant find it or I'm just confused.

I have 2 workbooks, Workbook A and Workbook B

Every week in Workbook A, new data is added to a new worksheet. In
Workbook
B, I need to reference several cells from Workbook A. But with each new
week,
I need to change the sheet name in all of the references to get the weeks
data. The only thing that will be changing in Workbook B is the sheet name
in
each external reference.

Is there any way to easily change the sheet name in each external
references
in Workbook B without doing anything to Workbook A?