Hi,

In my workbook, I have a global variable sheet called "GlobalVars" and
individual worksheets.

The GlobalVars will have variables that affect all calculation sheets. My
variables are localized to this sheet.

An individual worksheet represents a region. It will use both specific
region inputs and global variables (brought over from GlobalVars) . It
performs the region's calculations. Again, all variables are localized.

I want to be able to duplicate an individual worksheet as many times as
needed. But when I do this, the variables from GlobalVars break. I am left
with #N/A.

Any ideas or thoughts on how to approach this?

I look forward to your help.

Best regards,
Kevin