You can define external variables in a workbook and use them anywhere in the spreadsheet as and when required.

For more information, refer to Creating and Using a External Variable.