If you've got many references to change, the INDIRECT function sounds like
what you need. Use one cell for the name of the relevant sheet, & pick that
up in the link formulae.
--
David Biddulph

"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?