Help with drag and drop auto fill

[Smarty]

Hi,

I hope someone can help.

I Have a number of identical worksheets all with mulitple formulas contained within and i am looking to create a summary sheet i have used the $ sign to stop the rows increasing as i drag and the formula but i cant get the sheets to increase by an increment of 1 i.e.

formula in A1: ='Sheet1'$B$3 when i drag to the right i want the formula to show ='Sheet2'$B$3 constantly increasing the sheet only for every cell right i drag.

Is this even possible, i've been going round in circles for hours!!

Many thanks in advance

Smarty

 

[VoG]

Try in A1

=INDIRECT("'Sheet"&COLUMN()&"'!B$3")