Skip Row if result is blank

[peterpan1279]

Hi,
Thanks in advance for your assistance.

I have a workbook which contains a master document sheet and 14 worksheets with various if(and or vlookup statements to extract the data as we need it at our centre.

I wasn't able to sort the data alphabetically with iferror leave cell black, so I changed it to if error "zz". I am now having to sort 14 sheets A-Z every time I make a change to my workbook...very time consuming and frustrating. I'm looking for a way to not have to sort my worksheets, to have it done automatically or is there a way to skip rows if the data doesn't match the formula? I don't have any experience in Macros

I have removed a lot of the pages from my workbook example. The sheet that I am trying to skip rows is the 'Dolphin Chn' one. Data is coming from the other sheets. I have used conditional formatting to make ZZ entries white, so they won't be visible.

2014 Master Document example.xlsx

Thank you,
Sarah