I have a workbook that contains 40 plus worksheets.

I have a control sheet with this workbook.

I want the user to be able to enter the information needed only on the
Control sheet.

Once that information is updated, i.e. Checkboxes checked, #s inputted.

I want those values to automatically update the different worksheets.

Besides doing '='location'. Is there a way that excel can handle this or do
I have to hardcode it in Vb.

Any assistance would be greatly appreciated.

Thanks