Lookup Values And Include New Rows As Needed

I am looking to build a VBA to do the following action:

Look up an ID number from column F (ID numbers are separated by an empty row at current),
then check whether there is a corresponding value in columns N to P,

if there are values, copy them onto a different sheet into three different columns

if there values below this particular row, i.e. if the rows below say row 9 (where we looked up the ID number) in columns N - P are not empty, also copy all these values and add additional rows as needed on the sheet this is copied to

then look up the next ID in column F and do the same until there are no more IDs