To anybody that can help please

I have built a spreadsheet which shows whether my companys drivers are re-fulling there vehicles.

I am struggling to make a front sheet to collate all my data into one simple view.

There are only 3 tabs,


Unfuelled Check NEW.xls


On The front page tab i need a forumla that populates names from B13 downwards.

The data is being collected from the Fueling Tab..... this is were it gets complicated.....

I need data from the Driver Coloumn for a week so ( W9:W40, AB9:AB40, AG9:AG40, AQ9:AQ40, AV9:AV40, BA9:BA40)

I do not want to include "NOT USED"

I would also only like the drivers names to be populated if the reason code is "02:Driver Error" from cells X9:X40, AC9:AC40, AH9:AH40, AR9:AR40, AW9:AW40, BB9:BB40,

There is a fleet tab with all the drivers names.

Is this just too complicated or can it be done???

If anyone has a way of simplifying this I would be very Grateful.

Thanks
Majort