Okay,
I thought there are five for each item.
So use this in D3
=IF(INDEX(INDIRECT("'"&MID(D$1,FIND(CHAR(1),SUBSTITUTE(D$1,"/",CHAR(1)))-1,1)+0&"-0"&MID(D$1,FIND(CHAR(1),SUBSTITUTE(D$1,"/",CHAR(1),2))-1,1)+0&"'!A:A"),MATCH(INDIRECT("A"&3+QUOTIENT(ROW(A1)-1,5)*5),INDIRECT("'"&MID(D$1,FIND(CHAR(1),SUBSTITUTE(D$1,"/",CHAR(1)))-1,1)+0&"-0"&MID(D$1,FIND(CHAR(1),SUBSTITUTE(D$1,"/",CHAR(1),2))-1,1)+0&"'!A:A"),0)+MOD(ROW(A1)-1,5))=INDIRECT("A"&3+QUOTIENT(ROW(A1)-1,5)*5),INDEX(INDIRECT("'"&MID(D$1,FIND(CHAR(1),SUBSTITUTE(D$1,"/",CHAR(1)))-1,1)+0&"-0"&MID(D$1,FIND(CHAR(1),SUBSTITUTE(D$1,"/",CHAR(1),2))-1,1)+0&"'!E:E"),MATCH(INDIRECT("A"&3+QUOTIENT(ROW(A1)-1,5)*5),INDIRECT("'"&MID(D1,FIND(CHAR(1),SUBSTITUTE(D1,"/",CHAR(1)))-1,1)+0&"-0"&MID(D1,FIND(CHAR(1),SUBSTITUTE(D1,"/",CHAR(1),2))-1,1)+0&"'!A:A"),0)+MOD(ROW(A1)-1,5)),"")
and this in E3
=IF(INDEX(INDIRECT("'"&MID(D$1,FIND(CHAR(1),SUBSTITUTE(D$1,"/",CHAR(1)))-1,1)+0&"-0"&MID(D$1,FIND(CHAR(1),SUBSTITUTE(D$1,"/",CHAR(1),2))-1,1)+0&"'!A:A"),MATCH(INDIRECT("A"&3+QUOTIENT(ROW(A1)-1,5)*5),INDIRECT("'"&MID(D$1,FIND(CHAR(1),SUBSTITUTE(D$1,"/",CHAR(1)))-1,1)+0&"-0"&MID(D$1,FIND(CHAR(1),SUBSTITUTE(D$1,"/",CHAR(1),2))-1,1)+0&"'!A:A"),0)+MOD(ROW(A1)-1,5))=INDIRECT("A"&3+QUOTIENT(ROW(A1)-1,5)*5),INDEX(INDIRECT("'"&MID(D$1,FIND(CHAR(1),SUBSTITUTE(D$1,"/",CHAR(1)))-1,1)+0&"-0"&MID(D$1,FIND(CHAR(1),SUBSTITUTE(D$1,"/",CHAR(1),2))-1,1)+0&"'!G:G"),MATCH(INDIRECT("A"&3+QUOTIENT(ROW(A1)-1,5)*5),'7-01'!A:A,0)+MOD(ROW(A1)-1,5)),"")
They are very very long!!!Lol!!
Now copy D3:E3 and paste across to F3:W3 or till the right end.
Now all formulas are pasted in first row.
Now copy the first row i.e. D3:W3 and copy down till end.
Hope this would work!!
Bookmarks