I have a sheet i am creating to log my teams work tasks. I need to have a summary sheet that brings the data out of worksheets within the workbook to a summary sheet. The functions required are
1. Auto pick data that has a flag indicating it as an active task
2. Show that data in the summary sheet in the same format as the referenced/data entry sheet
3. They will all have a cell that indicates it as an active task, a description of task and a name assigned to task. (this is the only data that will need to be in the summary sheet)
4. The data entry sheets will have different data sets but this does not need access at this time until i have the base functions in.

Or would it be better to use access.....

If you can help that would be great i can send sheet if required