summarising the data from various sheets

dear friends!

I have an excel 2010 file which consist of 100 sheets of similar format with certain data. i want to summarise with relevant fields by using sheetname.

example : '11'!m18 like wise '15'!m18
like wise i have to link up the around 30 fileds of various sheets ( above sheet nos.are 11 and 15 and data fields are m18). cell address of summary is similar except the sheet name should change in the formula dynamically without manual intervention and that too by draging the previous formula to next cell.

do the needful, thanks in adv.