I have a cell reference in my last worksheet of my workbook e.g. =Sheet1!B5

All the other worksheets are set up in the same way and so I am trying to
copy this refence so that I would get =Sheet2!B5 =Sheet3!B5 etc. so that it
saves me time not having to change all the cells manually. My guess is, this
is not possible as worksheets are absolute and not relative?! Or is there any
smart way how to get around this problem?

Kind regards

Nicole