I want to make a an excel cell copy from another cell in the same document but different page at a click of a button. I want it to copy a name from another cell not a number
For the 'click of a button' part you'd need to use VBA. Simple exmaple:
Code for point (4) above: note that this copies from cell B1 to cell A1. You can replace those with any cell values, of course, but also with a name rather than a cell address. For example, if you have a named cell of "MyVal", you'd put "MyVal" in the place of "B1" or "A1".