The issue I have is I don't know which formula (or combination of formulas) will allow me to use specific columns and specific rows to build a new table.

here is an example of the data

blank row*

Data Title(1)

Table Title(2)

cell1(3) cell2 cell3 cell4 cell5 cell6(4)

cell1(3) cell2 cell3 cell4 cell5 cell6(4)

cell1(3) cell2 cell3 cell4 cell5 cell6(4)

cell1(3) cell2 cell3 cell4 cell5 cell6(4)

blank row*

Table Title(2)

cell1(3) cell2 cell3 cell4 cell5 cell6(4)

cell1(3) cell2 cell3 cell4 cell5 cell6(4)

cell1(3) cell2 cell3 cell4 cell5 cell6(4)

cell1(3) cell2 cell3 cell4 cell5 cell6(4)

blank row*

Table Title(2)

cell1(3) cell2 cell3 cell4 cell5 cell6(4)

cell1(3) cell2 cell3 cell4 cell5 cell6(4)

cell1(3) cell2 cell3 cell4 cell5 cell6(4)

cell1(3) cell2 cell3 cell4 cell5 cell6(4)

0