Calling a value from same cell number of different worksheets

If I have an excel file having multiple sheets, is there any sort of equation to call a value from every sheet onto a new sheet from a particular cell number. (eg: If I need to have a particular data on cell number suppose {a1:b1} of every sheet onto a new sheet, is there any formula or equation to do so in a bulk format [like calling {a1:b1} from 150 sheets of a single file on to each row of the new sheet]. So if I write the equation and drag down that value, only my sheet number of the equation changes, and the rest values remain const.)