Can I paste text inside a box on sheet 1 that automatically paste into a cell in sheet 2?

Can I paste text inside a box on sheet 1 that automatically paste into a cell in sheet 2? I'm trying to make sheet one look more like a web page. I want to be able to create text boxes on sheet one that will automatically copy the text into a certain cell in sheet 2. Seems like I seen something a long time ago where you go to sheet2 and in the cell you want the text to show up, you type in something like =sheet1 box1 I've attached my excel file incase you need to see what I'm not doing a good job of explaining. lol Thank You. Temp Testing.xlsx