How do i

1. make a name for a cell/ range available to all worksheets in the same
work book.

and/or

2. assign an already used name to the corresponding cell/range in another
worksheet in the same workbook.

The reason I need this is to make after thought formulas using names
available across worksheets in the workbook