how to collect data from other work sheets

Hope some one can help

I need to do a summary of a number of worksheets within a workbook

The only problem is that in the workbook there is one worksheet that has a set number of fields, now this cannot be changed, so if the data entered is to large for that worksheet then the user has to copy that work sheet and rename it accordingly. So how can i include data from these extra sheets with out re-writing the summary sheet, there is no way of nowing how many sheets could end up in the workbook

This could be a tough one or not ... lol

Hi drgogo

If you are summing the same cell through the sheets then if you have two dummy sheets called say First & Last which go at the beginning and end of the book you can then use a formula like this

=sum('first:last'!A1)

Any new sheets are inserted between First and Last

Ed

if doing it that way, is there a way of hidding those sheets so that they dont get inthe way or get altered. the less on the screen the better

Yes >Format > Sheet > Hide