Copy formula that spans several rows of data

Hi guys,

I have been manually entering a nested IF statement row after row for some time now and decided to see if there is a better way to accomplish this. Attached is a screenshot of a portion of my raw data.

Untitled.png

What I want to do is extract the data collected for each sample to its own worksheet within this excel file. So my loop consists of "IF this sample is sample 1 then copy this cell, IF this sample is sample 2 then copy this cell, and so on." Attached is an image of what I want as an end result.

Individual Sample.png

The issue I am having is that my IF formula has to check 6 different rows for each time measurement. For example, at t=0.25 hrs my formula checks values in rows 9 through 14 and for t=0.50 hrs the formula checks values in rows 15 through 20. Whenever I try to copy my nested loop formula from one row to the next the values due not iterate the way I need them to. Is there a way to do this, or am I stuck typing away?

Thanks!