Akash
I use Named Formula in my example
If you got the Name Manager,
got Formulas, Name Manager tab
Select either Late or OnTime
You will see the formula is like:
=OFFSET(Sheet1!$B$5:$B$10,,MATCH(Sheet1!$A$2,Sheet1!$B$3:$G$3,0))
To add more data simply extend the $G$3 to your last column eg:$X$3
same with the other formula