offset, multiple sheets

[ice1980]

I have two worksheets. The second worksheet (sheet2) contains three sets of data, organized by rows. The first worksheet (sheet1) refers to that data, with each set organized by columns. For example, in sheet1, the first cell is something like, "=sheet2!b2", which comes from the first set of data. The second set of data is to be displayed the next column over in sheet1, so, if I were to type manually, "=sheet2!b6". This could be very time consuming. Is there a way (in sheet1) to say that my second set of data is the same as the first set of data, offset by some number of rows? Here's a link to the workbook. Thanks for the help!

 

[ice1980]

I have actually included more conditions for this case. The updated spreadsheet is here. Again, even though all the "objects" in "set a" have no spatial relationships, "set b" will essentially follow the same 'pattern', separated by a fixed amount of rows. Thanks again.