Vlookup and Drop Downs

Hi - Thanks so much for your assistance.  I have attached a simplified version will only the data columns that I am interested in.  So what I am trying to achieve, is when I select the plan name on the first tab, the business area, plan ID, Primary Res Rep, Process Tier and Process Names all auto populate.  However, with the Process Names there are multiple.  Sp I either need the Process Name row to have a drop down with the assosiated Processes listed so that the user can select the ones they want to include, or, if easier, just list all the processes (1 on each row) in column F (only want those with a Tier rating of 1, 2 or 3 included).

Thanks for helping.