multiple worksheets input to one
 

Apologies if this has ever been covered, but search doesn't seem to work
...

I have a workbook w/ multiple sheets of identically formatted lists
containing rows with columns of dates and text (dates, names &
corrective action information). I would like to have the information
from all nine sheets duplicated on a single tenth sheet and when new
information is added to any of the nine worksheets for that data to be
automatically added onto the tenth as well. The nine worksheets are
based on input source while I would like to be able to sort all the
data onthe "summary" sheet by due date and priority.

help?


--
darustsPosted from http://www.pcreview.co.uk/ newsgroup access