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?