Vlookup or Macro for finding matching data

In the spreadsheet I want my lookup value to be in column D (ex. ALK22010) then in the multiple data sets( ALK Equity, AAI Equity ect.) find a matching value starting with Column Q then X then AE ect. If the value can be found in one of the data sets then I would like to return the value from the "Day" column in the data set. For all matches I would like the data from the "Day" column returned to column J. I attempted to do a vlookup in column I for the first two data sets and the formula works but could not get the Vlookup to work when I tried to include a 3rd, 4th, 5th ect.. data set into the formula. If anyone knows how to write a long Vlookup statement that would be helpful or can write a macro to do this would be great! Thanks

Can anyone help?