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?