how do you populate a list using several worksheets?

[sidmark1]

I am currently trying to create a fault log. I need an overview worksheet which will list the info from 10 columns of data from variable worksheets, depending on if the fault is resolved or not. (Column 9 on table asks and answers this question!!)

I.E.. All faults resolved = overview page empty

January's worksheet 2 unresolved faults
march's worksheet 1 unresolved fault

Overview will show three entry's showing info from column 2-11 of indicated worksheet.

Is this a) possible?
b) plausable?

Iam a complete excel novice and have bluffed my way through the rest of the sheet using Datedif and some conditional formating. Any help anyone could give would be greatly appreciated!!

Thanks Sid

 

[Skybluekid]

can you send the file or a sample of the data