When you paste the value there should be a little clipboard that shows up
next to the cell. Click on that and then click on the button that says link
cells.

"Carl" wrote:

I want to copy a formula to multiple worksheets with part of the formula
referencing the value of a cell in the previous worksheet without having to
manually change the worksheet name in the formula each time I paste it. Is
there a way that excel will automatically reference the cell in the previous
sheet as it does when copying and pasting within the same worksheet.

Thanks for any insight anyone could provide.

Cheers!
Carl