Updating Problem with Worksheet

I have a worksheet that obtains information from another worksheet by using If statements. My problem is if I use a command button I have on the primary worksheet to delete a row it returns an reference error on the second worksheet. Not sure how to fix this because I need to be able to delete rows from the primary worksheet without leaving a blank row on the sheet. I also can not have blank rows on the second worksheet (pivottable) I have attached a sample book with the command button that I am using. Just FYI the Logsheet worksheet is filled from an input page. Thanks for any help. jrg