|It depends on what you are trying to do. More details would help.|
A simple formula can accomplish your goal.
If you put this formula in a cell on any sheet in the workbook, it will always reflect what is in Sheet 1 cell A1
There are many other ways, but we would need more details before we could offer other suggestions.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.