Aray within an array

Good Morning All,
I need to find an array within an array.
I have attached a workbook in which essentially there are many matricies along side one another.
I would like to find a value 1-5 in row 2 of tab 'sub data' based on the date ('sub data' row 1) defined by the value in C1 on the tab 'main page'

Please help