List generation based on a Criteria

I'm developing a spreadsheet which automatically generate a list based on a certain criteria. I have partially done the work i want but have a little problem in optimizing the issue.

For reference i'm enclosing the spreadsheet with the data and requirement. Looking for a Solution.