Pulling a list of data from a larger table based on criteria

Hi, I am trying to automate a spreadsheet for pulling together information on the month's projects and their status's but having difficulty finding how to do what I want - if it is even possible... ...