I have a workbook that has about 10 worksheets. Each worksheet is a Departmental list of upcoming tasks. I need to create another worksheet that will look at each of the other worksheets and show me a list of all of the tasks that are within 30 days of being due. I don't want to have to look at every individual worksheet to find all of the coming due tasks - I would like the current ones to show up just on this one sheet. - so searching a date column - and returning both the date and the corresponding task in another column.
