Thanks JBeaucaire

thats just what im after,

but the data thats fetched from sheet1 in the first table only seems to bring the ref column data over to all the corresponding columns in the mats order, the other table works great, but the formulas look the same i cant seem to see any difference.