Google-sheets – Using checkbox to copy data form worksheet A to worksheet B

If Week 1 is in A1 of both sheets, 1 is in A2 of a worksheet etc then this might suit in B1 of another:

 =index(a!$A:$D,2,match($A1,a!1:1,0))  

copied across to C1 and the 2 there replaced by 3.

I have inserted two worksheets on your sample, one named Master and the other Results.

In Master, I have simply copied the original data.

In Results, I copied the results table and added a helper row and a helper column. The helper row contains the hours in number format (0400 to mean 00:00-04:00, 0800 to mean 04:00-08:00, etc) and the helper column contains the value from column D for the same row. I will mention here that it would be simpler to make the two worksheets have matching row data.

Then in cell C4 of Results, I used the formula:

=if(sum($B4:B4)=$B4*2,"",if(Master!$B4<C$3,$B4,""))

If I have to break it into smaller parts:

• if(Master!$B4<C$3,$B4,"") is responsible for ensuring this cell is the appropriate cell (with respect to the time) in which the value has to be inserted, and

• if(sum($B4:B4)=$B4*2 verifies if we already inserted a value in a previous cell on the same row. I highlighted some cells in cream; those would also have values if it wasn't for this part.