#REF! error when I delete a line on master sheet

I'm trying to create a workbook where I enter data into sheet 1, outputs in the format in sheet 2. The lines in sheet 1 need to be able to be deleted, but when I do, it breaks the link in the formula...