Hello

I have a workbook with 4 worksheets within it (ACTIONS, ISSUES, RISKS,
PLAN). Each worksheet's first column is 'Due Date' and the second column is
'Status' (with either 'completed' or 'in progress' in each cell).

I want to have add a SUMMARY worksheet tab that summarises all the cells
within the workbook that have tasks in progress. i.e. the 'Status' columns
from the ACTIONS, ISSUES, RISKS, PLAN worksheets to be shown in one
worksheet; only where the status is 'in progress' (not completed), and to
show the 'due date' and any other relevant information from each row, from
each worksheet.

basically instead of going to each worksheet tab and filtering by 'in
progress' and sorting the due date order, I will be able to see all
outstanding tasks in one summary sheet.

Does anyone know the formula (VLOOKUP i presume) that will show (in the
summary worksheet) all tasks in progress with the due date in ascending order?

ive done this before but i cant remember it, it was something about naming
the range and locking cells with the $ symbol (if you dont use it you loose
it!!)

many thanks!!