Locking cell value connected to a different workbook

Hello,

I am currently using excel 2010 for our weekly payroll. As of now, I have 2 workbooks. First is where I input the workers daily attendance and overtime which also computes the total salary for the week (Summary), and second is where I created a format for the pay slips that I print (Pay Slips). I was able to reference the value of the cells of the pay slips from the summary in order to save time in copying each details for each pay slip before printing. However, I need to update the list (based on the position and salary rate) weekly. So, every time I insert/delete a row on the summary, the value of the cells on the pay slips changes (e.g. Salary details of Worker 1, moves to Salary details of Worker 4 {after inserting/deleting rows}). Is there a way to fix/lock the value of the cell even if I insert/delete a row? Thank you in advance.