Automatically increment sheet reference when dragging formula

Question

I have a formula with the following syntax:

=SheetName!E10  

and need some way to drag the formula and change just the sheet name as it moves to the right. So the E10 part needs to stay the same with the sheet number incrementing as I drag the formula. We have many rows and columns to do and this would definitely speed us up.

Is this possible?

So the result would look like this:

=Sheet1!E10    =Sheet2!E10    =Sheet3!E10

This is the result:

from applying this formula:

=INDIRECT("mo"&COLUMN()+0&"!B4")  

Answer 1

Please try:

=INDIRECT("Sheet"&COLUMN()+x&"!E10")  

where x is the offset to return the appropriate number ( Column()+x ) for wherever you choose to place the formula.

Edit to match subsequent details from the image (where 5 may be in ColumnB) and a comment, perhaps should be:

=INDIRECT("mo"&COLUMN()-1&"!E10")