Linking Worksheets and Copying by Dragging

Is there anyway to copy a link from another worksheet and then use the mouse to select and drag down and have the worksheet numbers automatically updated? I paste a link ='12'!$E$23, I am trying to take that cell and drag down and get ='13'!$E$23, ='14'!$E$23, etc.


Thanks in advance.

No, not automatically, because worksheet names can be anything, not just numbers.

To do something like this you can use the INDIRECT function to build the reference as a string. Suppose that you want to refer to the sheet name that corresponds to the row number you are in (i.e., the link in row 10 refers to '10'!$E$23) then you could use a formula like this:

=INDIRECT("'"&ROW()&"'!$E$23")