Question: how to copy and paste cells between sheets in excel?
Answer: Copy the cells (Ctrl/Command + C, or right click and choose Copy). Go to the other tab (Sheet2) and click on the cell (or cells) where you want to place the links.