I don't understand the problem from your example workbook. There's only one sheet with any data. To best help you, we'll need to see the exact layout you're using (with dummy data).

As for a solution, my first thought is that this is possible with either VBA or an Indirect/Index/Match combination. Both have their advantages and disadvantages. VBA cannot be undone with a simple Ctrl+z if the macro is run in error or you want to check to see what the effects were before. It can also be more difficult to debug/change and, if someone disables macros, your sheet won't work. The formula route doesn't have these weaknesses, but since Indirect is a volatile function, the sheet will recalculate with every change you make to the workbook, potentially slowing it down if the sheet is large and complex. Also, the tabs will have to exactly match the row headings for Indirect to work.