try the indirect function
I assume the 0510 is a date
=indirect("'05"&(row()+adder)&"'!B4")
where the adder is the number necessaary to add to the row number to make it
be the day you are interested in

alternately you could put in a columns with the name of the sheets
=indirect("'"&sheetrange cell&"'!B4")

"John" wrote:

hi!


I have big list of worksheets in one book. Every sheet is named by date and
in every sheet there are some number in exact same place. Now I need to
create a list of number in new sheet. For instance I have the number in cell
"B4" in every worksheet. For decreasing my time to copy and paste from
hundreds of sheets I need excel to do it for me.

If I drag from first function excel takes new sheet but same cell

like this:
='0510'!B4
='0511'!B4
='0512'!B4
='0513'!B4
='0514'!B4

and so on.

is it possible?