I have an interesting challenge for the excel guru out there. I have a workbook that has a tab for Quarter-to-date employee data and then seperate tabs after that for Month-to-date data for employees. The Quarter-to-date tab has two formulas per employee that pulls data from each of the Month-th-date tabs. If we never added or removed any employees from any of the tabs this would be fine. However, when we add an employee, for example, in alphabetical order that requires us to insert row(s) which moves the cells that are linked to formulas. For example, Jack Doe's formula in the QTD "Billables" cell is the following: [=Dec.12!C9+Nov.12!C9+Oct.12!C9]. If we add employee in the row right above him in December that pushes his cells down to C10 instead of C9 and thus throws the formula off. How can we link all cells connected with a certain person's name to a formula in another tab of the same workbook? I have attached the sample woExcel Example.xlsxrkbook I'm referring to