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?
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?