find cell with date and return vaue in cell next to it

[caman06]

I am trying to copy data from a group of workbooks to a master workbook but have run into a problem where the source files data are in different cells depending on individual workbook.

so is there a way I can search for the string "Date:-" which appears in a group of merged cells, then return the value in the merged cells next to it to the right.

I have no option of getting rid of merged cells as this is historic data.

is there someway I can do a vlookup and successfully return the date in the next group of cells,

For eg cell Range C6:I6 = string "Date:-"
value required is in range J6:S6.

Thanks in advance

 

[makiwara]

Can you make a screenshot, so we can see, what's the exact problem? Or at least rearrange your dates in a form of table so its easier to understand.