hi,

i have spreadsheets for work which could have anywhere between 5 and 100
worksheets within. i am creating a worksheet at the end of the workbook which
takes information from all worksheet and puts it into the last one. is there
anyway to have this info from seperate worksheets automatically going in the
the Last worksheet with out having to put in all the coding? and secondly, is
there a way to set it up so that if a new worksheet is added then the last
spreadsheet will add a line and put in the new info.

i am hoping so.
Thanks in advance if anyone can help