What is the naming convention for the sheets? Does it use Sheet1, Sheet2,
etc. or the month name or the date range, or something?


"iwilkin" wrote in message
...

Hi,

I have a workbook with an undefined number of sheets in it. On each of
these sheets i have a body of data. I'd like to be able to look at all
this data in total on one sheet.

For example, i have a phone bill for each month on seperate worksheets
and i want to be able to analyse the whole call activity over the total
time.

Is it possible to use a macro to pull all this data into a summary
sheet that i can then analyse?

Many thanks in advance for your help


--
iwilkin
------------------------------------------------------------------------
iwilkin's Profile:
http://www.excelforum.com/member.php...o&userid=16072
View this thread: http://www.excelforum.com/showthread...hreadid=373455