I have two worksheets and one is my template that I link cells to in my
second worksheet.

I have multiple columns and rows that I'm linking to. When I want to create
a new row in my second worksheet I used to select the first cell and type =
and then go to my first worksheet and click the cell that I want it to link
to.

Then to complete the row, I used to just copy and paste the cell I just
linked on my second worksheet and it wouldn't copy that particular cell, but
rather the "formula" of the link and it would link to the similar cell in the
row/column of the first worksheet.

Now all of a sudden when I copy and paste it pastes the cell, rather than
the "formula". Why? How can I change it back?