How to remove blank lines from VLookup or IF statement spreadsheet

I have a workbook that has a worksheet that contains information for many individuals from different towns. I am trying to set up individual worksheets within the workbook for each town. On the individual worksheet, I want to list all information for the individual from the main worksheet. My question is, I can use VLookup or IF statements to get the information over but it creates blank lines. How do I get these blank lines to not be there. I know this would be better in Access and that I can use a quick filter on my main sheet but I would like to see if I can get Excel to do this.

Thank you for you help