Multiple worksheets, multiple workbooks
 

Hi

I have had a workbook foisted on me which is to be distributed to my
managers and it has 52 sheets in the form wk 1, wk2.....wk 52 etc. I need to
be able to pull in the weekly data for the workbooks they forward and these
will include all weeks. I have done stuff like this before using lookup but
that will only work if the data is in a continuous array I guess?

What I would like to be able to do on the collation sheet is put a week
number into a cell and have it populate the collation sheet with the totals
from the various returns. All the return sheets are structured identically,
I'm sure I could do this in a long winded and cack handed way but I'm hoping
there will be a nice, elegant and time saving way!!

All suggestions gratefully received!!

Peter

you should be able to type a week number in a1 - head each week across the
columns for individual sheets and then do a lookup.

"peter marsh" wrote:

Hi

I have had a workbook foisted on me which is to be distributed to my
managers and it has 52 sheets in the form wk 1, wk2.....wk 52 etc. I need to
be able to pull in the weekly data for the workbooks they forward and these
will include all weeks. I have done stuff like this before using lookup but
that will only work if the data is in a continuous array I guess?

What I would like to be able to do on the collation sheet is put a week
number into a cell and have it populate the collation sheet with the totals
from the various returns. All the return sheets are structured identically,
I'm sure I could do this in a long winded and cack handed way but I'm hoping
there will be a nice, elegant and time saving way!!

All suggestions gratefully received!!

Peter